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;
