JOINSUMGROUP BY
Return order_id and total revenue (quantity * unit_price summed) as revenue for every order in order_items. Sort by revenue descending, then order_id ascending.
Guest mode · solve history stays on this device; code isn’t saved. Sign in to save future work
query.sql
loading editor…
Run your code to see its output, or check your solution to grade it.