$1\mathrm{.}10$ on $15\mathrm{.}7$ join queries test your skills assessment

$1\mathrm{.}10$ Suppose you live in the West DePaul neighborhood and are concerned about the rise in a particular category of crime. You have a meeting scheduled with a member of your alderman's staff to discuss the issue. To prepare for the meeting, you need to prepare a list of the crimes.

List all crimes reported in the community area associated with your neighborhood $($West DePaul$)$ with an IUCR primary description of "NARCOTICS".

Show the primary$\_$description, secondary$\_$description, date, district, and block.

Sort the results by arrest then by secondary description then by crime$\_$id$.$