Good job. Finally, we can sort rows by multiple columns. Take a look:
SELECT * FROM employee ORDER BY department ASC, level DESC;
In the query above, we first sort all employees by the department in the ascending order, and then by the level in the descending order. As we mentioned before, rows are sorted in the ascending order by default, so the keyword ASC after the department column is not required – we only added it for clarity.
The German couple loves big hotels, remember? Now, show the columns name, city and room_count from the hotel table. Sort the results first by the city in the ascending order, and then by the room_count in the descending order.
Type:
SELECT name, city, room_count FROM hotel ORDER BY city ASC, room_count DESC;
