Queries with Restrictions Assessment

This database contains data about crimes reported in the city of Chicago during $2018.$

$1\mathrm{.}1$What are the details of the community area named "O'Hare"?

Show the community area number, side, and population.

Remember that to refer to column value in the WHERE clause that includes an apostrophe $(\text{'})$ you must either use double quotes around it $("$O$\text{'}$Hare$")$ or put a backslash in front of the apostrophe $(\text{'}$O$\backslash \text{'}$Hare$\text{'}).$

$10$

$1\mathrm{.}2$What is the contact information for district #$17?$

Show the district name, fax, and address.

$10$

$1\mathrm{.}3$List the crimes reported to have occurred on blocks ending in $"$N LEGETT AVE".

Show the date, block, report number, ward number, and community area number.

Sort the results by date then by block then by report number.

$10$

$1\mathrm{.}4$In Chicago, crimes are classified using Illinois Uniform Crime Reporting $($IUCR$)$ standards. List the IUCR secondary descriptions with a primary description of "LIQUOR LAW VIOLATION".

Show an alphabetical list of secondary descriptions.

$10$

$1\mathrm{.}5$List the crimes reported with an IUCR NUMBER of $"110"$ that occurred in ward NUMBER $37$ where no arrest has been made.

Show the date, case number, FBI code, and district number.

Sort the results by date then by case number.

$10$

$1\mathrm{.}6$List the crimes reported in district #$20$ where no location description has been reported.

Show the date, case number, community area number, and district number.

Sort the results by date then by case number.