Case study: the bakery's September · exercise 1 of 1 · free preview
Revenue for one item is quantity × unit price. Join the three tables, then group by the day.
The owner wants daily revenue. Show each order_date and the total revenue that day, named revenue, earliest date first.
Tables in this practice shop
customersproductsordersorder_items