SQL practice: Running Totals and Frames
Chapter 25 · 9 questions · included in full access
Question 1 · easy
Solve it in your browserShow a running total of quantity in order_items, ordered by order_item_id.
Question 2 · easy
Solve it in your browserShow each product's price and what percent it is of all prices added together.
Question 3 · medium
Solve it in your browserShow a running total of orders per month, over time.
Question 4 · medium
Solve it in your browserFor each branch, show a running total of its revenue ordered by date.
Question 5 · medium
Solve it in your browserShow monthly order counts with a 3-month moving average.
Question 6 · medium
Solve it in your browserShow each employee's salary and what percent of the total payroll it is.
Question 7 · medium
Solve it in your browserShow branch revenues with a running cumulative percentage, biggest branch first. (This is a Pareto / 80-20 chart.)
Question 8 · hard
Solve it in your browserShow each product with its revenue and its category's total revenue beside it.
Question 9 · hard
Solve it in your browserShow revenue per order date with a running total. Every row shows the same grand total. Fix it.
These questions are part of full access.
The first chapters of every track are free. Full access is a one-time payment.
See pricing