$1\mathrm{.}6$ Build a detailed list of crimes against Society reported to have occurred in district $6$ at locations with a description of "GROCERY FOOD STORE".

Show the case number, IUCR primary description, IUCR secondary description, ward number, and block.

Order the result by secondary description then primary description.

Note: Only include crimes where the "crime$\_$against" column equals "Society".

$($D$)10$

$1\mathrm{.}7$ Build a community$-$area crime report showing each incident of stalking.

Include crimes reported in Chicago's "Far Southwest" side with a primary description of "STALKING".

Show the community area name, secondary description, arrest, district, and block columns.

Sort the results by secondary description then by arrest then by community area name.

$($D$)10$

$1\mathrm{.}8$ List the crimes reported to have occurred at exactly $8$:$00$ am on April $28,2018.$

Show the title from the FBI$\_$code table, ward, district, location description, and case number.

Sort the results by district then by title then by ward.

$($D$)10$

$1\mathrm{.}9.$ Suppose you work for alderman Matthew O'Shea in the office of ward #$19.$ The alderman would like to discuss progress on the cases of a particular category of crime with commanders of the districts where the crimes occurred. Generate a list to facilitate this discussion.

List all crimes reported in ward #$19$ with an IUCR primary description of "NARCOTICS".

Shnus the nrimary decrintion cornndary docrintian dictrict arract$-$caca numbor