Question: Hoe do you do #3 for SQL code -World Country Profile: Aggregate functions This tutorial is about aggregate functions such as COUNT, SUM and AVG.


Hoe do you do #3 for SQL code
-World Country Profile: Aggregate functions This tutorial is about aggregate functions such as COUNT, SUM and AVG. An aggregate function takes function SUM would aggregate the values 2, 4 and 5 to deliver the single value 11. many values and delivers just one value. For example the continent ea opulation gdp Afghanistan Asia Albania Europe Algeria Atrica 2381741 37100000 188681000000 652230 25500100 20343000000 28748 2831741 12960000000 Andorra Europe 469 78115 3712000000 Angola Afica 1246700 20609294 1009000000 You might want to look at these examples first Using SUM, Count MAX, DISTINCT and ORDER BY Total world population 1. Correct answer Show the total population af the world. SUM(populatio.. 7118632738 world (name, continent, area, population, gdp) GDP of Africa 3. Error: Give the total GDP of Africa Unknown column Africa' in 'where clause Submit SQL Restore default
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
