LOGICAL OPERATOR - AND

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 above 13 and below 70. In other words, both conditions must be fulfilled to retrieve a particular row.


SELECT column_name FROM table-name WHERE column_name > value AND column_name <value ;


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

VIN

1HGCM82633A004352