SELECT WEEK(sale_date) AS week_number, SUM(amount) AS total_sales FROM sales GROUP BY WEEK(sale_date);