(Solved): please help the formula bar. the formula bar, General D MyEducator Tasks the formula bar to the form ...

the formula bar. the formula bar, General D MyEducator Tasks the formula bar to the formula bat to the formula bar crimes reported in the city of Chicago during 2018. (1.1) What are the details of the community area named "O'Hare"? 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 (") you must either use double quotes around it ("O'Hare") or put a backslash in front of the apostrophe ('O\'Hare'). E 10 1.2) What is the contact information for district #14? • Show the district name, phone, and email. E10 (1.3) List the crimes reported to have occurred on blocks ending in "S FARRAR DR". . Show the date, block, report number, ward number, and FBI code number. Sort the results by block then by date then by report number. E 10 14) In Chicago, crimes are classified using Illinois Uniform Crime Reporting (IUCR) standards. List the IUCR secondary descriptions with a primary description of "CONCEALED CARRY LICENSE VIOLATION". Show an alphabetical list of secondary descriptions. 10 Give Feedback to 100% hula bar. mula bar. rmula bar. CARRY LICENSE VIOLATION". Show an alphabetical list of secondary descriptions. OE 10 (1.5) List the crimes reported with an IUCR NUMBER of "1130" that occurred in ward NUMBER 10 where no arrest has been made. Show the date, case number, district number, and community area number. • Sort the results by case number then by date. A E 10 1.6 List the crimes reported in district #25 where no location description has been reported. • Show the date, case number, FBI code, and block. • Sort the results by case number then by date. 10 1.7 List the crimes reported in district #3 with an IUCR number of 554 along with those reported in ward #41 with an FBI code number of 24. • Show the case number, FBI code number, ward number, IUCR number, district number, arrest, 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 A rmula bar DMyEducator Tasks formula bar formula bar Sort the results by IUCR number then by district number then by FBI code number then by ward number then by case number. E 10 (18) List the crimes reported between latitudes 41.877 and 41.878 (inclusive) that have a location description of "PARK PROPERTY". Show the date, case number, community area number, and block. • Sort the results by date then by case number. E10 1.9 Which wards had at least one crime with an IUCR number of "610" (BURGLARY) reported at a location with a description of "PAWN SHOP"? • Show only the ward number in ascending order. • Be sure your result does not include any duplicates. E 10 (1.10 List the location descriptions where crimes with an IUCR number of "1345" (CRIMINAL DAMAGE) have occurred in ward #41. 2 Show only the location description in alphabetical order. Be sure your result does not include any duplicates. E10 Did you encounter any tase tema Chicago X ot.com/2021/01/chicago- Database Diagram for Chicago Crime Data 1-2002-2003-2004-2005-2006-2007-2008-2009-2010-2011-2012-2013-2014-2015-2016-2017-2018-2019 District district no district name address zip code commander email phone fax tty twitter FBI Code fbi code no title description crime against Community Area community area no community area name side population PAIN tity_Arm Crime report no case number date block lucr no location description arrest domestic beat district no ward no fbi code no community area no latitude longitude location Neighborhood neighborhood name o community area no Cier Linda Ham IUCR lucr no primary description secondary_description index code. Ward ward no. alderman_first name alderman last name) ON alderman name suffix ward office address ward_office_zip ward email ward office phone ward office fax city hall office room city hall office phone city hall office fax population