Question: I need help with the MongoDB portion : Load these data in a relational database (e.g., PostgreSQL), a graph database (e.g., Neo4j), and a document
I need help with the MongoDB portion :
Load these data in a relational database (e.g., PostgreSQL), a graph database (e.g., Neo4j), and a document database (e.g., MongoDB).Your goal is to determine the median and average accident severity for each type of motorcycle. Write the queries to find the median and average accident severity for each type of motorcycle. Show the results of these queries.
From the Accidents.csv file:
AccidentSeverity the code for the severity of the accident.
AccidentIndex a unique identifier for the accident.
From the Make_Model.csv file:
AccidentIndex unique identifier for the accident.
VehicleType the vehicle code for the vehicle involved in the accident.
From the Vehicles.csv file
code the vehicle code
label the corresponding vehicle type for this code
I have loaded the data in, now i need help with the join statement and the average and median accident severity for each type of motorcycle i.e. vehicle label from the vehicles table must contain the word motorcycle.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
