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

Instruction

Great! Now, instead of all the information, we'd like to only show selected columns. How do we do that? Take a look:

SELECT full_name, department
FROM employee;

The query above only shows columns full_name and department for all rows from the employee table. The other columns (id, level, is_full_time) won't be shown.

Exercise

Now, select the name and city columns from the hotel table.

Stuck? Here's a hint!

Type:

SELECT name, city
FROM hotel;