Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Learn SQL Webinar

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;