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

Good job. Now, let's see how the WHERE clause works with numerical columns. Take a look:

SELECT *
FROM employee
WHERE level < 3;

In the query above, we show only those employees whose level is lower than 3. We use the less than sign (<) to that end. In a similar way, we could use greater than (>), equal to (=) and not equal to (!=).

Exercise

The German couple would like to stay at a big hotel.

Select all the information from the hotel table for hotels with more than 50 rooms.

Stuck? Here's a hint!

Type:

SELECT *
FROM hotel
WHERE room_count > 50;