Assessment Section $1$

$1$

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 #$9?$

Show the district name, fax, and phone.

$10$

$1\mathrm{.}3$

List the crimes reported to have occurred on blocks ending in $"$W MONTROSE DR$".$

Show the date, block, report number, beat, and ward number.

Sort the results by block then by date 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 "INTERFERENCE WITH PUBLIC OFFICER".

Show an alphabetical list of secondary descriptions.

$10$

$1\mathrm{.}5$

List the crimes reported with an IUCR NUMBER of $"430"$ that occurred in ward NUMBER $42$ where an arrest has been made.

Show the date, case number, beat, and ward number.

Sort the results by case number then by date.

$10$

$1\mathrm{.}6$

List the crimes reported in district #$17$ where no location description has been reported.

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

Sort the results by date then by case number.

$10$

$1\mathrm{.}7$

List the crimes reported in district #$6$ with an IUCR number of $1754$ along with those reported in ward #$2$ with an FBI code number of $9.$

Show the case number, FBI code number, ward number, IUCR number, district number, date, and block.

Sort the results by IUCR number then by district number then by FBI code number then by ward number then by case number.

$10$

$1\mathrm{.}8$

List the crimes reported between latitudes $42\mathrm{.}003$ and $42\mathrm{.}004($inclusive$)$ that have a location description of "STREET".

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

Sort the results by date then by case number.

$10$

$1\mathrm{.}9$

Which wards had at least one crime with an IUCR number of $"495"($BATTERY$)$ reported at a location with a description of "ALLEY"?

Show only the ward number in ascending order.

Be sure your result does not include any duplicates.

$10$

$1\mathrm{.}10$

List the location descriptions where crimes with an IUCR number of $"1206"($DECEPTIVE PRACTICE$)$ have occurred in ward #$37.$

Show only the location$\_$description in alphabetical order.

Be sure your result does not include any duplicates.