WHERE region = 'AMER' AND amount > 50000 needs both. OR needs either. IN ('a','b') is a short OR. IS NULL tests for missing values; = NULL never matches. Comparisons: =, <> (not equal), <, >, <=, >=, BETWEEN x AND y.