SQL AND Tutorial - Interactive Database Lesson

Lessons

AND

Interactive SQL Tutorial

In the WHERE part of a query, you can search for multiple attributes by using the AND keyword. For example, if you wanted to find the friends of Pickles that are over 25cm in height and are cats, you would run:
SELECT * FROM friends_of_pickles WHERE height_cm > 25 AND species = 'cat';

Can you find all of Pickles’ friends that are dogs and under the height of 45cm?

SQL:

SQL AND Tutorial - Interactive Database Lesson

Lessons

AND

Query Result:

Available Tables:

Expected Result: