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;
