data analysis of vehicle accidents using SQL

- This case study involved answering 6 key questions to derive valuable insights from the data:

1- How do the number of accidents in urban areas compare to rural areas?

2- Which day of the week experiences the highest volume of accidents?

3- What is the average age of vehicles involved in accidents, broken down by vehicle type?

4- Are there specific weather conditions that contribute to more severe accidents?

5- Do accidents tend to involve impacts on the left-hand side of vehicles?

6- Are there relationships between the purpose of the journey and the severity of the accidents?

- Please feel free to check the detailed SQL queries and data files in my github