Each task asks for an order. The check compares the order of your rows too.
- The customers in the order they signed up, first signup first:
name, thensignup_date. - The employees, highest salary first:
name, thensalary. - The products from cheapest to most expensive. Two products have the same price: put the one with more stock first. Show
name,price, thenstock. - The customer names, sorted by city from A to Z. Show
nameonly, not the city. - Think before you run it: Grace Okafor has no city. Where is her row in
SELECT name, city FROM customers ORDER BY city DESC;: first or last?