Script from QA Apprenticeship
Data analysis project using government data about road accidents. Has two tasks code writen in SQL.
To analysis if White van man are the cause of motor accidents.
White vans are responsible for a large number of motor accidents?
Data will come from the make_model table and the Vehicle_Type table
Vehicles that not classed as motor will be excluded from the study. These include: 'Agricultural vehicle', 'Mobility scooter', 'Pedal cycle', 'Ridden horse', 'Tram'.
Question and Answers: “Motorists had suggested that the ‘white van man’ type of driver caused more accidents. Irrespective of which type of vehicle was associated with the highest count of accidents, can any such conclusion applied to any type of vehicle be drawn from the results?” The data is broken down by vehicle type and does not have a personal data on the drivers, only generic data list sex and age. So it would not be possible to prove this statement.