随笔分类 -  SQLZOO

用于存储sqlzoo刷题答案
SQLZOO: Self join
摘要：stops(id, name) route(num, company, pos, stop) stops id name route num company pos stop 1.How many stops are in the database. SELECT COUNT(DISTINCT(st 阅读全文
posted @ 2020-09-11 10:54 格格木miss 阅读(467) 评论(0) 推荐(0)
SQLZOO: Using Null
摘要：teacher iddeptnamephonemobile 101 1 Shrivell 2753 07986 555 1234 102 1 Throd 2754 07122 555 1920 103 1 Splint 2293 104 Spiregrain 3287 105 2 Cutflower 阅读全文
posted @ 2020-09-11 10:09 格格木miss 阅读(195) 评论(0) 推荐(0)
SQLZOO: More JOIN operations/zh
摘要：This tutorial introduces the notion of a join. The database consists of three tables movie , actor and casting . movie id title yr director budget gro 阅读全文
posted @ 2020-09-10 21:27 格格木miss 阅读(330) 评论(0) 推荐(0)
SQLZOO: The JOIN operation/zh
摘要：game idmdatestadiumteam1team2 1001 8 June 2012 National Stadium, Warsaw POL GRE 1002 8 June 2012 Stadion Miejski (Wroclaw) RUS CZE 1003 12 June 2012 S 阅读全文
posted @ 2020-09-10 18:12 格格木miss 阅读(166) 评论(0) 推荐(0)
SQLZOO: SUM and COUNT/zh
摘要：World Country Profile: Aggregate functions This tutorial is about aggregate functions such as COUNT, SUM and AVG. An aggregate function takes many val 阅读全文
posted @ 2020-09-10 09:48 格格木miss 阅读(232) 评论(0) 推荐(0)
SQLZOO：SELECT within SELECT Tutorial/zh
摘要：This tutorial looks at how we can use SELECT statements within SELECT statements to perform more complex queries. namecontinentareapopulationgdp Afgha 阅读全文
posted @ 2020-09-07 11:28 格格木miss 阅读(270) 评论(0) 推荐(0)
SQLZOO: SELECT from Nobel Tutorial/zh
摘要：nobel yrsubjectwinner 1960 Chemistry Willard F. Libby 1960 Literature Saint-John Perse 1960 Medicine Sir Frank Macfarlane Burnet 1960 Medicine Peter M 阅读全文
posted @ 2020-09-07 10:26 格格木miss 阅读(389) 评论(0) 推荐(0)
SQLZOO:SELECT from WORLD Tutorial
摘要：namecontinentareapopulationgdp Afghanistan Asia 652230 25500100 20343000000 Albania Europe 28748 2831741 12960000000 Algeria Africa 2381741 37100000 1 阅读全文
posted @ 2020-09-06 14:02 格格木miss 阅读(326) 评论(0) 推荐(0)