Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
See the whole table
Select some columns
Filtering rows
Logic
10. Logical operators – AND
Text patterns
To be or NULL to be
A little bit of mathematics
Let's practice

Instruction

Excellent! Of course, OR isn't the only logical operator out there. Take a look at the next example:

SELECT
  id,
  name
FROM user
WHERE age <= 70
  AND age >= 13;

AND is another logical operator.

In this case, only those users will be selected whose age is 13 or above and 70 or below. In other words, both conditions must be fulfilled to retrieve a particular row.

Exercise

Select vin of all cars which were produced after 1999 and are cheaper than 7 000.

Stuck? Here's a hint!

Type:

SELECT vin
FROM car
WHERE production_year > 1999
  AND price < 7000;