摘要:
七:The OUTER JOIN: (http://sqlzoo.cn/4.htm) 1a. 一个议员被开除出党,看看他是谁 SELECT Name FROM msp WHERE Party IS NULL 1b. 列出所有政党和领导者 SELECT Name, Leader FROM party 1c. 列出所有有领导者的政党 SELECT Name,Leader FROM party WHER... 阅读全文
摘要:
五:How to do joins(http://sqlzoo.cn/3b.htm) 1a. Show the athelete (who) and the country name for medal winners in 2000 SELECT who, country.nameFROM ttmsJOIN countryON (ttms.country=country.id)WHERE gam... 阅读全文
摘要:
四:Aggregate functions(http://www.sqlzoo.cn/2.htm) 1a. 显示世界人口总和 SELECT SUM(population) FROM bbc 1b. 列出所有的地区,但每个地区只能显示一次 SELECT DISTINCT region FROM bbc or:SELECT region FROM bbc GROUP BY region1c. 显示GD... 阅读全文
摘要:
一:SELECT(http://www.sqlzoo.cn/1.htm) 1a. 查看关于bbc表的详细说明 SELECT name, region, population FROM bbc 2a. 给出人口不小于2亿的国家的名称.(2亿是200000000,有8个0) SELECT name FROM bbc WHERE population>= 200000000 2b. 给出人口不小... 阅读全文