Road Accident Analysis.Pt2 (SQL)

Analyzing incident severity distribution reveals that slight accidents surpass serious and fatal ones.

Furthermore, accidents on dry roads outnumber those on wet, muddy, or snowy conditions, suggesting minimal

impact on accident rates in adverse weather.

Visibility's influence on accidents shows a higher occurrence in light conditions compared to darkness.

The relationship between speed regulations and accident frequency highlights a peak at a 30-speed limit.

Surprisingly, almost all accidents occur on the right-hand side of vehicles, indicating negligible impact on the left side.

Our chart explores relationships between journey purposes and accident severity, indicating that commuting

to/from work has the highest accident frequency among various trip motivations.