5 SQL practice questions in our Amazon collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
2 Easy · 1 Medium · 2 Hard
Independent practice resource. Not affiliated with or endorsed by Amazon.
These topics come from the questions in this set. Pick one to open the matching problems.
Find all products that had no orders placed in March 2026. Return product_id, product_name, and category. This helps identify inventory that might need restocking or promotional attention.
Calculate the 7-day rolling average of daily order value (completed orders only) for each product category. Return category, order_date, daily_order_value, and rolling_7d_avg. This helps identify trends and seasonal patterns in category performance.
Analyze retention for Prime vs Non-Prime customers across their first 4 weeks post-signup. Bucket cohorts by their signup week, then calculate what percentage of each cohort completed an order in each of the 4 weeks following signup. Return cohort_week, week_number (1-4), segment (Prime/Non-Prime), and retention_percentage.
5 Amazon problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Your dataset
product_id (INTEGER) · product_name (VARCHAR) · category (VARCHAR) · price (DECIMAL) · seller_id (INTEGER)
order_id (INTEGER) · customer_id (INTEGER) · product_id (INTEGER) · order_date (DATE) · total_amount (DECIMAL) · status (VARCHAR)
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice Amazon SQL free188 SQL practice questions. 23 companies. Free access to every problem.