Join the accident data to the Philly road network

[lrigell]

Hi!
When I ran my code for the 3rd step, I got the error "syntax error at or near "FROM""!
See my code below.
Is anyone else having an issue?
Sincerely,
Laura

SELECT accidents_philadelphia_street_id.street_id, accidents_philadelphia_street_id.distance, SUM(accidents_philadelphia_street_id.* ) as num_accidents, ???
FROM accidents_philadelphia_street_id, streets
LEFT JOIN accidents_philadelphia_street_id ON streets.id = accidents_philadelphia_street_id.street_id
GROUP BY streets.id