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