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


Perfect! We also have a true/false field in our table employee. How do we filter rows based on this column? Take a look:

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.


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!


FROM hotel
WHERE pets_allowed IS TRUE;