最近在练习sqlzoo上的习题,参考了网上一些资料,发现小部分习题已经有了更新,所以在此把自己的练习内容记录下来。
刚开始的题目特别简单,但是到了后面难度就逐渐加大了,不过在做题过程中,都会穿插有相应的知识点讲解,这点非常nice。
练习网址:https://sqlzoo.net/wiki/SQL_Tutorial
参考博客:https://blog.csdn.net/kangaroo835127729/category_2153583.html
知识点
where、in、between的基础用法
数据表
world
题目内容
1.The example uses a WHERE clause to show the population of 'France'. Note that strings (pieces of text that are data) should be in 'single quotes';Modify it to show the population of Germany.(示例展示了查找'France'的人口,题目要求把国家改为'Germany')
select population from world
where name = 'Germany'
2.Checking a list The word IN allows us to check if an item is in a list. The example shows the name and population for the countries 'Brazil', 'Russia', 'India' and 'China'.Show the name and the population for 'Sweden', 'Norway' and 'Denmark'.(示例展示了查找'Brazil', 'Russia', 'India' , 'China'人口,题目要求把国家改为 'Sweden', 'Norway' , 'Denmark')
select name, population from world
where name in ('Sweden', 'Norway', 'Denmark');
3.Which countries are not too small and not too big? BETWEEN allows range checking (range specified is inclusive of boundary values). The example below shows countries with an area of 250,000-300,000 sq. km. Modify it to show the country and the area for countries with an area between 200,000 and 250,000.(示例展示了查找面积在250,000-300,000的国家名称和面积,题目要求把面积改为200,000-250,000)
select name, area from world
where area between 200000 and 250000