-- Creating a filter for good vs poor driving conditions
ALTER TABLE PortfolioProject.dbo.SeattleCollision
ADD POORDRIVINGCOND bit;
UPDATE PortfolioProject.dbo.SeattleCollision
SET POORDRIVINGCOND = CASE 
		WHEN WEATHER = 'Clear' AND ROADCOND = 'Dry' THEN 0
		ELSE 1
	END;