Amazon practice guide
Stay inside one business context for a few reps in a row while still working from the same live bank used across practice, tracks, and reviews.
Amazon
Explore 17 Amazon-tagged SQL scenarios focused on query basics, aggregation, date functions.
Context, not signal
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed.
Sign in to track progress while you browse this guide.
Questions
17
Estimated prep time
295 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Amazon-tagged set.
Query basics
12
Aggregation
8
Date functions
2
Filtering
2
Joins
2
Mix at a glance
Use the difficulty and path mix to decide whether you want fundamentals, breadth, or stretch reps.
Suggested rhythm
Start with the easiest scenario in the set, then move upward while tracking accuracy and retry speed. This keeps the context stable while the difficulty rises.
Suggested next scenarios
The next best reps from this company-tagged set based on what you have not solved yet.
Departments Above Average Pay
Practice query basics through a Amazon-tagged business scenario.
2024 App Click Volume
Practice query basics through a Amazon-tagged business scenario.
Frequent Support Callers
Practice query basics through a Amazon-tagged business scenario.
Question list
The current Amazon-tagged list with learning objectives and your latest status.
Departments Above Average Pay
Use this Amazon scorecard to work on departments above average pay. Return each department_id whose average salary exceeds the company average salary for Mar...
Practice query basics through a Amazon-tagged business scenario.
2024 App Click Volume
Amazon wants a portfolio scan for 2024 app click volume. Return each app_id and the total number of click events recorded in 2024. Sort by app_id.
Practice query basics through a Amazon-tagged business scenario.
Frequent Support Callers
At Amazon, analysts are preparing a readout focused on frequent support callers. Return the distinct policy_holder_id values for members who made at least 3 ...
Practice query basics through a Amazon-tagged business scenario.
Late Shipment Rate By Carrier
At Amazon, analysts are preparing a readout focused on late shipment rate by carrier. Return the percentage of shipments that arrived late by carrier_name. O...
Practice query basics through a Amazon-tagged business scenario.
Creators With Multiple 2024 Posts
Use this Amazon analysis pass to work on creators with multiple 2024 posts. Return each creator_id that posted at least two items in 2024. Sort by creator_id.
Practice query basics through a Amazon-tagged business scenario.
Top Sellers By Gross Sales
Use this Amazon planning note to work on top sellers by gross sales. Return the top 3 sellers by total_gross_sales. Output seller_id and total_gross_sales so...
Practice query basics through a Amazon-tagged business scenario.
Number Of Unique Subjects Taught By Each Teacher
Amazon is reviewing number of unique subjects taught by each teacher through a diagnostic pass. Return each app_id and the total number of click events recor...
Practice query basics through a Amazon-tagged business scenario.
Odd And Even Transactions
Amazon wants a operations review for odd and even transactions. Return separate totals for odd-numbered and even-numbered measurement days. Return two column...
Practice query basics through a Amazon-tagged business scenario.
Loss-Making Drug Totals
Amazon is reviewing loss-making drug totals through a scorecard. Return each manufacturer with the number of loss-making drugs and the total absolute loss. S...
Practice query basics through a Amazon-tagged business scenario.
2128 Book Sales
SELECT b.book_id, COALESCE(SUM(b.unit_price*od.quantity), 0) as total_sales FROM amazon_books b LEFT JOIN amazon_books_order_details od ON b.book_id=od.book_...
Practice joins through a Amazon-tagged business scenario.
04 Easy Amazon Purchasing Activity By Product Type
-- purchasing activity by product type -- SELECT t1.order_date, t1.product_type, ( SELECT SUM(quantity) FROM total_trans AS t2 WHERE t2.order_date <= t1.orde...
Practice aggregation through a Amazon-tagged business scenario.
09. Average Review Ratings [Amazon Interview]
/* Given the reviews table, write a query to get the average stars for each product every month. The output should include the month in numerical value, prod...
Practice aggregation through a Amazon-tagged business scenario.
Average Product Review Ratings
Amazon is reviewing average product review ratings through a scorecard. The product quality team wants monthly review score reporting. For each product and m...
Practice aggregation through a Amazon-tagged business scenario.
Store Refund Share
Retail finance wants to compare refund pressure by store for April 2024 orders. Return store_id, total_sales, refunded_amount, and refund_pct rounded to two ...
Practice query basics through a Amazon-tagged business scenario.
Category Revenue Leaders
During June 2024, each category had multiple products generating revenue. Return the highest-grossing product_id in each category along with category and tot...
Practice query basics through a Amazon-tagged business scenario.
Second-highest Salary
At Amazon, analysts are preparing a performance snapshot focused on second-highest salary. Return the second-highest salary amount in the table as second_hig...
Practice query basics through a Amazon-tagged business scenario.
05 Medium Amazon Highest Grossing Items
-- highest grossing items -- WITH top_sales AS ( SELECT category, product, SUM(spend) AS total_spend FROM product_spend WHERE DATE_PART('year', transaction_d...
Practice aggregation through a Amazon-tagged business scenario.