Best April deals - hours only!Up to 80% off on all courses and bundles.-Close
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;