1.8 List the crimes reported between latitudes 42.008 and 42.009 (inclusive) that have a location description of "OTHER"

[answerhappygod]

1 8 List The Crimes Reported Between Latitudes 42 008 And 42 009 Inclusive That Have A Location Description Of Other 1 (42.55 KiB) Viewed 45 times

1.8 List the crimes reported between latitudes 42.008 and 42.009 (inclusive) that have a location description of "OTHER". a. Show the date, case number, ward number, and block. b. Sort the results by case number then by date. 1.9 Which wards had at least one crime with an IUCR number of "1121" (DECEPTIVE PRACTICE) reported at a location with a description of "DEPARTMENT STORE"? a. Show only the ward number in ascending order. b. Be sure your result does not include any duplicates. 1.10 List the location descriptions where crimes with an IUCR number of "4387" (OTHER OFFENSE) have occurred in ward #9. a. Show only the location_description in alphabetical order. b. Be sure your result does not include any duplicates.