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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!