Weekday vs Weekend Orders
Medium
date-functions
Uber
DoorDash
Instacart
Given an orders table with order_date and amount, write a query that classifies each order as 'Weekday' or 'Weekend' based on the day of week, then returns the order count and total amount for each classification.
Tables
Hints (2 available)
SQL Editor
Output
Click "Run" to see results...