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?