advanced sql case exercises with answers
rs in the following order: 'Pending', 'Processing', 'Shipped', 'Cancelled'. Write a query to list all orders ordered by their priority. Solution: ```sql SELECT order_id, customer_id, order_date, status FROM orders ORDER BY CASE status WHEN 'Pending' THEN 1 WHEN 'Processing' THE