Question: 4 . 4 . 1 : Aggregate functions. 5 4 6 3 8 6 . 3 9 5 9 5 7 0 . qx 3

4.4.1: Aggregate functions.
546386.3959570.qx3zqy7
ID Name Capital PopulationMillions Continent Code
364 Iran Tehran 81.8 Asia IRN
554 New Zealand Wellington 4.84 Oceania NZL
112 Belarus Minsk 9.48 Europe BLR
72 Botswana Gaborone 2.25 Africa BWA
300 Greece Athens 10.73 Europe GRC
466 Mali Bamako 19.08 Africa MLI
CountrySELECT Continent, SUM(PopulationMillions)
FROM Country
GROUP BY Continent
HAVING SUM(PopulationMillions)>21;Which rows appear in the result of the following query?
1
2
3
4
5

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!