How to Apply 2 AND Operators Correctly?

Hello,
I’m doing the New York Restaurants Project.

Playing around with the queries, and would like to see all the Chinese restaurants, with $ price, where health isn’t NULL.

This is what I wrote, and it works perfectly when there’s just 1 AND operator (doesn’t matter if price/health), but when there’re 2 - nope.

SELECT *
FROM nomnom
WHERE cuisine = 'Chinese'
AND price IS = '$'
AND health IS NOT NULL;

Where am I wrong?

Thanks :slight_smile:

Hi there.

You don’t need the IS in this line. The = on its own is fine to say "where price is $".

Thanks for the prompt reply!