SQL Basics
Summary
Instruction
Perfect! We also have a true/false field in our table employee. How do we filter rows based on this column? Take a look:
SELECT * FROM employee WHERE is_full_time IS FALSE;
In the query above, we only show employees who don't work full-time. To show them, we used is_full_time IS FALSE. In a similar way, we could use is_full_time IS TRUE to only show those that do work full-time.
Exercise
Another requirements: the German couple would also like to take their dog with them.
Select all the information from the hotel table for hotels which allow pets.
Stuck? Here's a hint!
Type:
SELECT * FROM hotel WHERE pets_allowed IS TRUE;
