sqlzoo:SUM and COUNT

梦里梦外; 2022-12-27 01:50 156阅读 0赞

> 1.  Show the total population of the world.

SELECT SUM(population)
    FROM world

> 1.  List all the continents - just once each.

SELECT continent
    FROM world
    GROUP BY continent

SELECT DISTINCT continent
    FROM world

> 1.  Give the total GDP of Africa

SELECT SUM(gdp)
    FROM world
    WHERE continent = 'Africa'

> 1.  How many countries have an area of at least 1000000

SELECT COUNT(*)
    FROM world
    WHERE area >= 1000000

> 1.  What is the total population of (‘Estonia’, ‘Latvia’, ‘Lithuania’)

SELECT SUM(population)
    FROM world
    WHERE name IN('Estonia', 'Latvia', 'Lithuania')

> 1.  For each continent show the continent and number of countries.

SELECT continent, COUNT(*)
    FROM world
    GROUP BY continent

> 1.  For each continent show the continent and number of countries with populations of at least 10 million.

SELECT continent, COUNT(*)
    FROM world
    where population >= 10000000
    GROUP BY continent

> 1.  List the continents that have a total population of at least 100 million.

SELECT continent
    FROM world
    GROUP BY continent
    HAVING SUM(population) >= 100000000

发表评论取消回复

表情：

评论列表（有 0 条评论，156人围观）

还没有评论，来说两句吧...

相关阅读

相关 sqlzoo:SUM and COUNT

> 1. Show the total population of the world. SELECT SUM(population) FROM world

梦里梦外;/ 2022年12月27日 01:50/ 0 赞/ 157 阅读

相关 LeetCode38——Count and Say

LeetCode38——Count and Say 上一题对我来说实在太凶残了，所以我还是缓缓先做38题好了。。。题意：可以理解为求一个数组的第n项，而这个数组的通项

青旅半醒/ 2022年08月09日 09:21/ 0 赞/ 182 阅读

相关 38. Count and Say

The count-and-say sequence is the sequence of integers beginning as follows: `1, 11, 2

妖狐艹你老母/ 2022年07月15日 01:16/ 0 赞/ 129 阅读

相关 38. Count and Say

The count-and-say sequence is the sequence of integers beginning as follows: `1, 11, 2

男娘i/ 2022年07月15日 01:16/ 0 赞/ 142 阅读

相关 leetcode 38. Count and Say

The count-and-say sequence is the sequence of integers with the first five terms as foll

- 日理万妓/ 2022年06月09日 09:45/ 0 赞/ 137 阅读

相关 38. Count and Say

[38. Count and Say][] The count-and-say sequence is the sequence of integers with the f

Myth丶恋晨/ 2022年06月08日 11:14/ 0 赞/ 185 阅读

相关解决Count and Say

`` 一、题目： The count-and-say sequence is the sequence of integers with the first five te

电玩女神/ 2022年06月02日 06:20/ 0 赞/ 216 阅读

相关【Leetcode】38. Count and Say

38. Count and Say The count-and-say sequence is the sequence of integers with the first

布满荆棘的人生/ 2022年03月09日 03:06/ 0 赞/ 161 阅读

相关 38. Count and Say

The count-and-say sequence is the sequence of integers with the first five terms as foll

ゝ一纸荒年。/ 2022年03月07日 11:38/ 0 赞/ 238 阅读

相关 38. Count and Say

description: 就是看前面那个数有几个几，然后写一串。 Note: Example: The count-and-say sequence is

╰+哭是因爲堅強的太久メ/ 2021年10月18日 10:48/ 0 赞/ 297 阅读