each question is supposed to be a query from sql

$1.$ List the crimes reported to have occurred in vehicles in ward $8$ with a IUCR primary description of "NARCOTICS".

Show the secondary description, district, case$\_$number, and beat.

Crimes occurring in vehicles have a location that starts with "vehicle".

Sort the results by district then by secondary description.

$2.$ List the crimes reported with a primary description of "MOTOR VEHICLE THEFT" that occurred in ward #$3$ where an arrest has been made.

Show the primary description, ward, district, location description, and community area number.

Sort the results by primary description then by ward then by district.

$3.$ List the crimes reported between latitudes $41\mathrm{.}915$ and $41\mathrm{.}916($inclusive$)$ that have a location description of "RESTAURANT".

Show the title from the FBI$\_$code table, ward, district, beat, and block.

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

$4.$ Build a detailed list of all crimes reported to have occurred in locations under management of the Chicago Housing Authority in ward number $46$ where no arrest has been made.

Show the case number, IUCR primary description, IUCR secondary description, community area number, and district number.

Order the result by primary description then secondary description then case number.

Note: locations under the management of the Chicago Housing Authority begin with "CHA".

$5.$ Build a detailed list of crimes against Property reported to have occurred in district $11$ at locations with a description of "TAXICAB".

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

Order the result by secondary description then primary description.

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

$6.$ Build a community$-$area crime report showing each incident of arson.

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

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

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

$7.$ List the crimes reported to have occurred at exactly $9$:$00$ am on November $26,2018.$

Show the title from the FBI$\_$code table, ward, district, FBI code, and arrest.

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

$8.$ Suppose you work for alderman Emma Mitts in the office of ward #$37.$ 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 #$37$ with an IUCR primary description of "CRIM SEXUAL ASSAULT".

Show the primary$\_$description, secondary$\_$description, district, arrest, case$\_$number, commander, district phone number, FBI code, and block.

Sort the results by district then by secondary description then by arrest then by case$\_$number.

$9.$ Suppose you live in the Back of the Yards 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 $($Back of the Yards$)$ with an IUCR primary description of "CRIM SEXUAL ASSAULT".

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

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