Running Total of Daily Sales

Unsolved

Return each store's daily sales and cumulative sales, ordered by store then date.

Learn the concept: ROW_NUMBER vs RANK vs DENSE_RANK

SQL Query Editor (Ctrl+Enter to run)

0 characters · Valid

Canonical Solution Official

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Ask questions, share alternate queries, and explore solutions

0 comments

Asked By:

🏢 Walmart🏢 Stripe

Your recent query executions and answer checks

Execution Pipeline:

FROM DailySales

Full source dataset

6 rows total

Reveal Canonical Solution?

This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.