날아보자!

Population Census Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'. Note: CITY.CountryCode and COUNTRY.Code are matching key columns. Input Format The CITY and COUNTRY tables are described as follows: SELECT SUM(A.population) FROM CITY A JOIN COUNTRY B ON A.CountryCode = B.Code WHERE B.CONTINENT = 'Asia'; African Cities Given the CIT..

Weather Observation Station 2 Query the following two values from the STATION table: The sum of all values in LAT_N rounded to a scale of 2 decimal places. The sum of all values in LONG_W rounded to a scale of 2 decimal places.Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. Output Format Your results must be in the..

Revising Aggregations - The Count Function Query a count of the number of cities in CITY having a Population larger than 100,000. Input Format SELECT COUNT(*) FROM CITY WHERE POPULATION > 100000; Revising Aggregations - The Sum Function Query the total population of all cities in CITY where District is California. Input Format SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT = 'California'; Revis..

New Companies Amber's conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy: Given the table schemas below, write a query to print the company_code, founder name, total number of lead managers, total number of senior managers, total number of managers, and total number of employees. Order your output by ascending company_code. Note: The tables ma..