Autumn Offers - hours only!Up to 80% off on all courses and bundles.-Close
SQL Basics


Nice! SQL makes it also extremely easy to sort rows. Take a look:

FROM employee
ORDER BY department;

In the query above, we select all the information from the employee table and sort the rows by the department using a ORDER BY clause. In SQL, rows are sorted in the ascending order by default.


The German couple found a nice hotel thanks to our help. Now, they are beginning to think about another trip... let's help them pick something nice!

Show the name and city of all hotels. Sort the rows by the city name.

Stuck? Here's a hint!


SELECT name, city
FROM hotel
ORDER BY city;