5 SUM and COUNT Quiz-SQLZoo-CSDN博客

本文链接：https://blog.csdn.net/Tracy785/article/details/89434626

本文详细介绍了使用SQL进行数据查询的多种技巧，包括求和、计数、平均、最大值、最小值等聚合函数的应用，以及如何通过条件筛选、分组、排序来获取特定的数据分析结果。文章通过具体示例，如查询欧洲总人口、小于15万人口的国家数量、各地区平均人口密度等，展示了SQL的强大功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在这里插入图片描述
1. Select the statement that shows the sum of population of all countries in 'Europe’

SELECT SUM(population) FROM bbc WHERE region = 'Europe'

2. Select the statement that shows the number of countries with population smaller than 150000

SELECT COUNT(name) FROM bbc WHERE population < 150000

3. Select the list of core SQL aggregate functions

AVG(), COUNT(), MAX(), MIN(), SUM()

4. Select the result that would be obtained from the following code:

 SELECT region, SUM(area)
   FROM bbc 
  WHERE SUM(area) > 15000000 
  GROUP BY region

No result due to invalid use of the WHERE function

5. Select the statement that shows the average population of ‘Poland’, ‘Germany’ and 'Denmark’

 SELECT AVG(population) FROM bbc WHERE name IN ('Poland', 'Germany', 'Denmark')

6. Select the statement that shows the medium population density of each region

 SELECT region, SUM(population)/SUM(area) AS density FROM bbc GROUP BY region

7. Select the statement that shows the name and population density of the country with the largest population

 SELECT name, population/area AS density FROM bbc WHERE population = (SELECT MAX(population) FROM bbc)

8. Pick the result that would be obtained from the following code:

 SELECT region, SUM(area) 
   FROM bbc 
  GROUP BY region 
  HAVING SUM(area)<= 20000000

在这里插入图片描述