Problem with a question/mistake in question

Q.11.Write a query that selects all Warrant Arrests from the tutorial.sf_crime_incidents_2014_01 dataset, then wrap it in an outer query that only displays unresolved incidents

for the above question i think there is some mistake in it,because if we filter the inner query with category = warrant and resolution=arrests then for outer query with resolution=none will give 0 rows in the output as inner and outer table has nothing in common,
please clarify

in the inner query you have to filter on descript = 'WARRANT ARREST' and not category = warrant and resolution=arrests.

and resolution = None will work on outer query then

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.