1.1
Which FBI Codes have a crime_against value of "Property"?
Show the code and description.
Order the result by code.
1.2
What is the contact information for district #6?
Show the district name, fax, and commander.
1.3
List the crimes reported to have occurred on blocks ending in "W MYRTLE AVE".
Show the date, block, beat, and district number.
Sort the results by block then by date.
1.4
In Chicago, crimes are classified using Illinois Uniform Crime Reporting (IUCR) standards. List the IUCR secondary descriptions with a primary description of "CRIMINAL ABORTION".
Show an alphabetical list of secondary descriptions.
1.5
List the crimes reported with an IUCR of "484" that occurred in ward #17 where no arrest has been made.
Show the date, case number, community area number, and block.
Sort the results by case number then by date.
1.6
List the crimes reported in district #14 where no location description has been reported.
Show the date, case number, beat, and FBI code.
Sort the results by date then by case number.
1.7
List the crimes reported in district #4 with an IUCR of 2014 along with those reported in ward #37 with an FBI code of 19.
Show the case number, FBI code, ward, IUCR, district, block, and arrest.
Sort the results by IUCR then by district number then by FBI code then by ward number.
1.8
List the crimes reported between latitudes 41.938 and 41.939 (inclusive) that have a location description of "DRUG STORE".
Show the date, case number, district number, and community area number.
Sort the results by date then by case number.
1.9
Which wards had at least one crime with an IUCR of "1261" (DECEPTIVE PRACTICE) reported at a location with a description of "RESIDENCE"?
Show only the ward number in ascending order.
Be sure your result does not include any duplicates.
1.10
List the location descriptions where crimes with an IUCR of "440" (BATTERY) have occurred in ward #20.
Show only the location_description in alphabetical order.
Be sure your result does not include any duplicates.