Sales by Weekday

Return the total sales by weekday name for the weekday numbers where sales exist, ordered by weekday number (Monday = 1 ... Sunday = 7).

Table schema

Sales(id INT PRIMARY KEY, sale_date DATE, amount INT)

Sample data

id | sale_date | amount
1 | 2026-01-05 | 100
2 | 2026-01-20 | 50
3 | 2026-02-14 | 70
4 | 2026-04-01 | 40
5 | 2026-05-10 | 90
6 | 2026-07-04 | 60
7 | 2026-07-05 | 30