ORDER BY

-- Find all orders and sort them by required_date DESC and ship_date ASC
SELECT *
FROM orders
ORDER BY required_date DESC, shipped_date;