- 博客(4)
- 资源 (1)
- 收藏
- 关注
RSS订阅原创 SQLZOO习题答案4
Self join1.How many stops are in the database2.Find the id value for the stop 'Craiglockhart'3.Give the id and the name for the stops on the '4' 'LRT' service4.The query shown gives the number of routes that visit either London Road (149) or Craiglockhart
2020-06-27 12:55:11
706
原创 SQLZOO习题答案 3
More JOIN operations1.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 include the words Star Trek in the title). Order results by year4.W
2020-06-27 01:07:20
649
原创 SQLZOO习题答案2
The JOIN operation1.show the matchid and player name for all goals scored by Germany. To identify German players, check for: teamid = 'GER'2.Show id, stadium, team1, team2 for just game 10123.show the player, teamid, stadium and mdate for every German goal
2020-06-26 23:35:34
262
原创 SQLZOO习题答案
SELECT within SELECT Tutorial1.Bigger than Russia2.Richer than UK3.Neighbours of Argentina and Australia4.Between Canada and Poland5.Percentages of Germany6.Bigger than every country in Europe7.Largest in each continent8.First country of each continent (al
2020-06-26 21:14:28
561
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人