-- Creating a filter for Nighttime 
ALTER TABLE PortfolioProject.dbo.SeattleCollision
ADD NIGHTTIME bit;
UPDATE PortfolioProject.dbo.SeattleCollision
SET NIGHTTIME = CASE 
		WHEN TIMEOFDAY = 'Daylight' THEN 0
		ELSE 1
	END;