sqlzoo练习答案--SUM and COUNT
来源:互联网 发布:边缘融合软件 破解 编辑:程序博客网 时间:2024/05/19 12:14
World Country Profile: Aggregate functions
This tutorial is about aggregate functions such as COUNT, SUM and AVG. An aggregate function takes many values and delivers just one value. For example the function SUM would aggregate the values 2, 4 and 5 to deliver the single value 11.
1、Show the total population of the world.
2、List all the continents - just once each.
3、Give the total GDP of Africa
4、How many countries have an area of at least 1000000
5、What is the total population of ('France','Germany','Spain')
6、For each continent show the continent and number of countries.
7、For each continent show the continent and number of countries with populations of at least 10 million.
8、List the continents that have a total population of at least 100 million.
阅读全文
0 0
- sqlzoo练习答案--SUM and COUNT
- sqlzoo练习答案--SUM and COUNT
- SQLZOO SUM and COUNT
- SQLZOO(SUM and COUNT)Writeup
- SQLZOO习题答案 The nobel table can be used to practice more SUM and COUNT functions./zh
- SQLZOO 练习答案 SELECT_basic_names
- sqlzoo练习答案--Using Null
- sqlzoo练习答案--Self join
- sqlzoo练习答案--Using Null
- sqlzoo练习答案--Self join
- sqlzoo练习答案--SELECT basics/zh
- sqlzoo练习答案--SELECT names/zh
- sqlzoo练习答案--SELECT within SELECT Tutorial
- sqlzoo练习答案--The JOIN operation
- sqlzoo练习答案--More JOIN operations
- SQLZOO 练习答案 SELECT FROM world
- sqlzoo练习答案--SELECT names/zh
- sqlzoo练习答案--SELECT basics/zh
- Zookeeper 命令行
- 图的异或 dfs树+线性基
- 见微知著----POJ2051(最小堆)
- 菜鸟末端轨迹(解密支撑每天251亿个包裹的数据库)
- Linux bridge方式虚拟机ping过程解析
- sqlzoo练习答案--SUM and COUNT
- 毕设系列之Libx264实时视频流(YUV 420P转H264视频编码篇)
- MY_iOS_在项目构建时如何应用ccache
- 二维数组内存图解
- browser-sync 文件监听失败的解决方案
- 乘车路线
- spring 面试题
- 每日一点Js(三)
- NVIDIA Jetson TX2 进阶:Nsight Eclipse Edition