![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqlzoo
Sweeney Chen
厚积薄发!
展开
-
sqlzoo--select basics,select from world
sqlzoo(1)world表格:namecontinentareapopulationgdpAfghanistanAsia6522302550010020343000000AlbaniaEurope28748283174112960000000AlgeriaAfrica238174137100000188681000000A...原创 2019-07-20 12:12:24 · 277 阅读 · 0 评论 -
sqlzoo--select from nobel ,select in select
sqlzoo(2)select from nobel 字段:yr(年份),subject(奖项),winner(获奖者)yrsubjectwinner1960ChemistryWillard F. Libby1960LiteratureSaint-John Perse1960MedicineSir Frank Macfarlane Burnet...原创 2019-07-21 15:06:25 · 658 阅读 · 0 评论 -
sqlzoo--More JOIN operations
More JOIN operationsmovie电影(id编号,title电影名称,yr首映年份,director导演,budget预算,gross票房)actor(id编号,name姓名)casting(movieid电影编号,actorid演员编号,ord角色次序)列出1962年首映的电影,显示其id,titleSELECT id,title FROM movie WHE...原创 2019-08-25 14:56:06 · 358 阅读 · 0 评论 -
sqlzoo--sum and count
SUM and COUNTnamecontinentareapopulationgdpAfghanistanAsia6522302550010020343000000AlbaniaEurope28748283174112960000000AlgeriaAfrica238174137100000188681000000Andorr...原创 2019-08-27 00:00:30 · 390 阅读 · 0 评论 -
sqlzoo--the join operation
The JOIN operationTABLE game:id(編號)mdate(日期)stadium(場館)team1(隊伍1)team2(隊伍2)10018 June 2012National Stadium, WarsawPOLGRE10028 June 2012Stadion Miejski (Wroclaw)RUSCZE1003...原创 2019-09-02 18:58:56 · 441 阅读 · 0 评论 -
sqlzoo--using null
sqlzoo–using nulltable:teacher教师id編號dept學系name名字phone內線電話mobile流動電話1011Shrivell275307986 555 12341021Throd275407122 555 19201031Splint2293104Spiregrain328710...原创 2019-09-16 22:00:47 · 454 阅读 · 0 评论 -
sqlzoo--self join
sqlzoo–self join已有字段:table:stopstable:routeidnumnamecompanyposstop数据库中有多少个站点select count(id) from stops;找出车站‘craiglockhart’的idselect id from stopswhere name = ...原创 2019-09-18 20:03:02 · 649 阅读 · 0 评论