$1\mathrm{.}1$ What are the details of the community area named "OrHare"? Database Diagram for Chicago Crime Data

$2001-2002-2003-2004-2005-2006-2007-2008-2009-2010-2011-2012-2013-2014-2015-2016-2017-2018-2019$

a$.$ Show the community area number, side, and population.

b$.$ 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$\text{'}($Hare$\text{'}).$

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

Show the district name, address, and commander.

$1\mathrm{.}3$ List the crimes reported to have occurred on blocks ending in $"$E $57$TH DR$".$

Show the date, block, report number, ward number, and FBI code number.

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

$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

"OBSCENITY".

Show an alphabetical list of secondary descriptions.

$(2)10$

$1\mathrm{.}5$ List the crimes reported with an IUCR NUMBER of $"484"$ that occurred in ward

NUMBER $4$ where no arrest has been made.

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

Sort the results by case number then by date.

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

reported.

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

Sort the results by date then by case number.

$1\mathrm{.}7$ List the crimes reported in district #$3$ with an IUCR number of $554$ along with

those reported in ward #$47$ with an FBI code number of $24.$

Show the case number, FBI code number, ward number, IUCR number, district

number, beat, and date.

Sort the results by IUCR number then by district number then by FBI code number

then by ward number then by case number.

$1\mathrm{.}8$ List the crimes reported between latitudes $41\mathrm{.}953$ and $41\mathrm{.}954($inclusive$)$ that

have a location description of "BANKc".

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

Sort the results by date then by case number.

$1\mathrm{.}2$ Which wards had at least one crime with an IUCR number of $"484"($BATTERY$)$

reported at a location with a description of 'CTA PLATFORM'?

Show only the ward number in ascending order.

Be sure your result does not include any duplicates.

$1\mathrm{.}10$ List the location descriptions where crimes with an IUCR number of $"2825"$

$($OTHER OFFENSE$)$ have occurred in ward #$17.$

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

Be sure your result does not include any duplicates.