company sql set
Amazon
Amazon
SQL Set
Commerce analytics across reviews, products, customer behavior, returns, revenue, and ranking.
question list
Work through all 10 questions
Open a problem, write the query, check the expected output, then come back for the next rep.
Q01
Average Review Ratings
Aggregate ratings by product.
Q02
Highest-Grossing Items
Find top revenue-generating items.
Q03
Best-Selling Product
Rank products by sales volume.
Q04
Second Highest Salary
Use ordering or ranking for salary analysis.
Q05
Customers Who Ordered Every Product
Solve a relational division pattern.
Q06
Running Total of Sales
Use windows to build cumulative sales.
Q07
Most Active User
Find the user with highest activity.
Q08
Consecutive Login Days
Detect login streaks.
Q09
Top Customers by Spending
Rank customers by total spend.
Q10
Most Returned Product
Find products with the most returns.