SQL Excercises with SFPD¶

This is a landing page for a 4-part assignment of SQL exercises:

Due: Wednesday, October 24, 2017, 11:59 PM

Due: Friday, October 26, 2017, 11:59 PM

These exercises use the same SQLite database of SFPD crime incident data from 2012 through 2016. The zipped data can be downloaded here:

This data is a modified version from what SF data portal publishes:

Directions¶

Each exercise section has a set of exercises with a (perhaps too vague) prompt, such as:

Total number of incidents categorized as “ASSAULT”

And the expected results from a SQL query:

You’re expected to write the query:

SELECT
 COUNT(*) AS total_assaults
FROM
 incidents
WHERE
 category = 'ASSAULT';