这篇博客探讨了SQL查询的基本用法，包括根据人口范围筛选国家、以特定字符开头的选择、查找以特定字母结尾的国家、以及针对欧洲国家名称长度的查询。还展示了查询特定国家的人口密度和面积条件。示例中使用了`BETWEEN`、`LIKE`、`IN`等操作符，以及计算人口密度的方法。
1. Select the code which produces this table
SELECT name, population
FROM world
WHERE population BETWEEN 1000000 AND 12500002. Pick the result you would obtain from this code:
SELECT name, population
FROM world
WHERE name LIKE "Al%" 
3. Select the code which shows the countries that end in A or L
SELECT name
FROM world
WHERE name LIKE '%a' OR name LIKE '%l'4. Pick the result from the query
SELECT name,length(name)
FROM world
WHERE length(name)=5 and region='Europe'
5. Here are the first few rows of the world table:
6. Select the code that would show the countries with an area larger than 50000 and a population smaller than 10000000
SELECT name, area, population
FROM world
WHERE area > 50000 AND population < 100000007. Select the code that shows the population density of China, Australia, Nigeria and France
SELECT name, population/area
FROM world
WHERE name IN ('China', 'Nigeria', 'France', 'Australia')
扫一扫
308
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
