Using the City Jail database from attachment. Use an sql sub-query…

Question Answered step-by-step Using the City Jail database from attachment. Use an sql sub-query…  Using the City Jail database from attachment.Use an sql sub-query statement to answer the following:The city’s Crime Analysis unit has submitted the following data requests. Provide the SQL statements using subqueries to satisfy the requests.1. List the name of each officer who has reported less or equal than the average number of crimesofficers have reported. Computer Science Engineering & Technology Software engineering COMP 214 Share QuestionEmailCopy link Comments (0)