Use Common Sense Show Single Sql Query Output Answer Question Provide Ids Codes Final Ans Q37287684

Use your common sense on these. Show the single SQL query andthe output AND the answer to the question. DO NOT provide IDs orcodes in the final answer; all tables should have meaningful columnheaders. Use whichever database is appropriate. Many of these willbe difficult unless you use SUBQUERIES. For this assignment, define“large city” to be one with more than 3 million people in it.

10. Which countries have average city populations for the citiesrecorded in the database of at least 3 million but no more than 7million?

SQL>

OR

 

OR