Daily revenue
- SQL course
- Intermediate
- Lesson 43/115
- 5 min
Write the GROUP BY query for daily revenue.
Daily revenue
To find daily revenue you use SUM(amount) with GROUP BY sale_date.
SELECT sale_date, SUM(amount) AS revenue
FROM sales
GROUP BY sale_date;This query gives the total revenue per day.
sale_date, SUM(amount) AS revenue is selected from sales. Rows are grouped by sale_date; aggregate functions are computed per group.
Daily revenue — details
GROUP BY sale_date makes each date a group. SUM(amount) produces the daily total.
Adding ORDER BY sale_date shows daily revenue in chronological order; this table can feed a chart directly.
Practice Daily revenue
Compute daily revenue with GROUP BY sale_date and SUM(amount).
Starter code
-- daily revenue
SELECT sale_date,
FROM salesSample solution
SELECT sale_date, SUM(amount) AS revenue
FROM sales
GROUP BY sale_date;Expected output
sale_date revenue 2026-01-01 1500 2026-01-02 2300
Questions and answers
Review the lesson questions together with their answers. To test yourself, solve the lesson interactively.
1 Add GROUP BY
Question
SELECT sale_date, SUM(amount) AS revenue
FROM sales
____ sale_date;
Answer
SELECT sale_date, SUM(amount) AS revenue
FROM sales
GROUP BY sale_date;Explanation: GROUP BY is the right answer.
2 How is daily revenue computed?
- COUNT + WHERE
- GROUP BY tarih + SUM Correct answer
- DISTINCT + AVG
- ORDER BY
Explanation: Group by date and sum the amount.
3 Daily revenue: match the terms
| Term | Meaning |
|---|---|
sale_date |
date |
SUM |
sum |
GROUP BY |
group |
revenue |
revenue |