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