Solution to 20 questions with the traffic crash dataset.

solution.sql

SELECT RD_NO
WHERE weather_condition = "RAIN" 
AND crash_type = "INJURY AND / OR TOW DUE TO CRASH"
AND (INJURIES_FATAL = 0 or injuries_fatal is null)
AND crash_hour IN (13,14,15)
AND DAMAGE = "OVER $1,500"
and first_CRASH_type not in ('REAR END','TURNING'
    ,'ANGLE', 'PARKED MOTOR VEHICLE', 'HEAD ON'
    , 'FIXED OBJECT', "SIDESWIPE SAME DIRECTION")
AND STREET_DIRECTION in ("E","W")
AND TRAFFICWAY_TYPE = "DIVIDED - W/MEDIAN BARRIER"
AND STREET_NAME = "ERIE ST"