Nested Aggregations

Use a SQL subquery or CTE to compute daily order totals, average daily revenue, and the busiest day.