Using a CTE named order_totals (order_id, revenue), return orders with revenue over 30. Columns: order_id, revenue. Order by revenue descending.
Using a CTE named order_totals (order_id, revenue), return orders with revenue over 30. Columns: order_id, revenue. Order by revenue descending.
Answer
WITH order_totals AS ( SELECT order_id, SUM(quantity * unit_price) AS revenue FROM order_items GROUP BY order_id ) SELECT order_id, revenue FROM order_totals WHERE revenue > 30 ORDER BY revenue DESC;