SELECT 
	symbol,
    Name,
    CASE
      WHEN Name LIKE '%Inc' THEN 'Incorporation'
      WHEN Name LIKE '%Inc.' THEN 'Incorporation'
  	  WHEN Name LIKE '%Corp' THEN 'Corporation'
      ELSE 'Other'
    END AS PriceCategory
FROM
	SP500
    
    