sqlzoo刷题笔记-07 | The JOIN operation

网址：https://sqlzoo.net/wiki/The_JOIN_operation

 

1、show the matchid and player name for all goals scored by Germany. To identify German players, check for: teamid = 'GER'

显示德国队进球对应的matchid 和 player

SELECT matchid, player 
FROM goal 
WHERE teamid = 'GER'

2、Notice in the that the column matchid in the goal table corresponds to the id column in the game table. We can look up information about game 1012 by finding that row in the game table.

Show id, stadium, team1, team2 for just game 1012

在game表中查询赛事1012对应的 id, stadium, team1, team2

SELECT id,stadium,team1,team2
FROM game
WHERE id = '1012&