SELECT symbol, Name, Price, CASE WHEN Price > 200 THEN 'Expensive' WHEN Price <= 100 THEN 'Cheap' ELSE 'Middle' END AS PriceCategory FROM SP500