Good! So far, we only had control over what columns were shown. Now, we'd like to specify which rows should be selected too. Take a look:
SELECT * FROM employee WHERE department = 'Accounting';
In the query above, a new clause appeared: WHERE. It is used to filter rows. In this case, we only want to see rows where the department columns contains the text "Accounting". Employees from any other departments won't be shown at all. Note that we used the equality sign (=) and that 'Accounting' must be surrounded with single quotes.
We've got a German couple who would like to go and see the Eiffel tower. But they need to sleep somewhere!
Select all the information from the hotel table for hotels in Paris.
Type:
SELECT * FROM hotel WHERE city = 'Paris';
