Group by Day of Week
Medium
date-functions
DoorDash
Robinhood
Instacart
Write a query to find the total sales for each day of the week. Use STRFTIME to get the day name. Return day_of_week (0=Sunday through 6=Saturday) and total_sales, ordered by day_of_week.
Expected Output: Total sales grouped by day of week.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...