SQLZOO习题及答案--SELECT from WORLD Tutorial

meowing

于 2018-09-05 18:43:35 发布

阅读量1.7k

点赞数 1

CC 4.0 BY-SA版权

分类专栏： SQL

本文链接：https://blog.csdn.net/meowing/article/details/82428682

本文提供了SQLZOO SELECT教程的练习和解答，涵盖了如何从WORLD表中查询国家名称、人口、大陆、GDP等信息。通过WHERE过滤、计算人均GDP、按特定条件筛选国家等，涉及SQL的基础和进阶操作，如ROUND函数、条件查询、字符函数等。

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

SQLZOO: http://zh.sqlzoo.net/wiki/SELECT_from_WORLD_Tutorial

name	continent	area	population	gdp
Afghanistan	Asia	652230	25500100	20343000000
Albania	Europe	28748	2831741	12960000000
Algeria	Africa	2381741	37100000	188681000000
Andorra	Europe	468	78115	3712000000
Angola	Africa	1246700	20609294	100990000000
...

1.Read the notes about this table. Observe the result of running this SQL command to show the name, continent and population of all countries.

SELECT name, continent, population FROM world

2.How to use WHERE to filter records. Show the name for the countries that have a population of at least 200 million. 200 million is 200000000, there are eight zeros.