-- Adding more descriptive labels to the Severity column
ALTER TABLE PortfolioProject.dbo.SeattleCollision
ADD SEVERITY nvarchar(255);
UPDATE PortfolioProject.dbo.SeattleCollision
SET SEVERITY = CASE 
		WHEN SEVERITYCODE = 3 THEN '3—fatality'
		WHEN SEVERITYCODE = 2 THEN '2—injury'
		WHEN SEVERITYCODE = 1 THEN '1—property damage'
		ELSE '0—unknown'
	END;