sqlzoo练习
文章平均质量分 84
小舒的窝
UPDATE
展开
-
sqlzoo的练习----SELECT from Nobel
SELECT from Nobel1.Change the query shown so that it displays Nobel prizes for 1950. SELECT yr, subject, winner FROM nobel WHERE yr = 1950 2.Show who won the 1962 prize for Literature. SELECT...原创 2018-07-28 15:03:36 · 947 阅读 · 2 评论 -
sqlzoo练习--MORE JION
The JOIN operation1.List the films where the yr is 1962 [Show id, title] 2.Give year of ‘Citizen Kane’. 3.List all of the Star Trek movies, include the id, title and yr (all of these movies includ...原创 2018-07-30 16:04:33 · 296 阅读 · 0 评论 -
sqlzoo--Using Null
这里涉及两个表: teacher(id,dept,name,phone,mobile); dept(id,name); 1.List the teachers who have NULL for their department. SELECT name FROM teacher WHERE dept IS NULL 2.Note the INNER JOIN misses the...原创 2018-07-30 23:38:52 · 193 阅读 · 0 评论 -
sqlzoo--Self JION
1.How many stops are in the database. SELECT COUNT(*) FROM stops 2.Find the id value for the stop ‘Craiglockhart’ SELECT id FROM stops WHERE name = ‘Craiglockhart’ 3.Give the id and the name f...原创 2018-07-31 14:45:31 · 298 阅读 · 0 评论