-- demo 3: WHERE clauses and OPERATORS
SELECT * 
FROM SP500 
WHERE Sector = 'Industrials' AND Price > 200
ORDER BY Price ASC
LIMIT 5

-- Sector = 'Industrials' OR Sector = 'Health Care'
-- dividend_yield >= 1 AND dividend_yield <= 2 -- similar to BETWEEN
-- sector is NULL
-- dividend_yield BETWEEN 1 AND 2
-- Name LIKE '%Inc' -- finding part of the text
-- Sector NOT IN ('Utilities','Health Care') -- for multiple categories
-- Sector = 'Real Estate' -- case sensitive, need exact match
-- Sector = 'Industrials'
-- Sector <> 'Industrials'
-- price = 222.89