Daily revenue

Write the GROUP BY query for 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.

Compute daily revenue with GROUP BY sale_date and SUM(amount).

Show example solution

SELECT sale_date, SUM(amount) AS revenue
FROM sales
GROUP BY sale_date;

Add GROUP BY

SELECT sale_date, SUM(amount) AS revenue
FROM sales
____ sale_date;

Show answer

SELECT sale_date, SUM(amount) AS revenue
FROM sales
GROUP BY sale_date;

Next lesson: Best sellers