Question: Problem 3: SQL queries Consider two relation instances below, with the following schemas Country (country name, continent) City (city_name, country_name, isCapital, population) For each question

Problem 3: SQL queries Consider two relation instances below, with the following schemas Country (country name, continent) City (city_name, country_name, isCapital, population) For each question (a)-(c) below, write a SQL query and show (copy and paste) the returned result when the query is executed in the Oracle system. Country Country_Name Continent US Canada England German France Mali North America North America Euro un un Africa CityName New York, NY Washington, DC Philadelphia, PA Ottawa Toronto Berlin Hambur Country_Name US US US Canada Canada Germany German isCapital Population 8,000,000 600,000 1,500,000 800,000 2,500,000 3,500,000 2,000,000 no es no Bonn Paris German France France Mali Mali Mali 300,000 2,000,000 700,000 2,000,000 50,000 100,000 no no Bamako Timbuktu Mopti no no (a) List the average population and number of all European cities with population of more than 600,000 (b) Identify the city with largest population for each country. List its country name, and the population. (c) For each country, list its name and belonging continent, along with its total population that is over 1 million. Also sort the result by the total population in descending order
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
