1.比赛编号matchid和球员名球员,该球员代表德国队德国入球的。要找出德国队球员,要检查: teamid = ‘GER’
SELECT matchid ,player
from goal
WHERE teamid = 'GER'
//入球看goal表,限制一下必须是德国
2.只显示赛事1012的ID,球场,Team1,Team2
SELECT id, stadium, team1, team2
from game
where id = 1012
3.修改它来显示每一个德国入球的球员名,队伍名,场馆和日期。
SELECT player,teamid,stadium,mdate
FROM game g JOIN goal d ON (g.id=d.matchid)
where d.teamid= 'GER'
4.列出球员名字叫Mario(player LIKE ‘Mario%’)有入球的队伍1 team1,队伍 2 team2和球员名player
select a.team1,a.team2,b.player
from game a join goal b