我一直在研究SQLzoo问题，但在JOIN教程问题#13中的最后一个问题上遇到了麻烦-列出每场比赛以及每个团队的得分，如图所示。链接:http://sqlzoo.net/wiki/The_JOIN_operation在他们给出的示例代码中，它使用了一个案例。我是这样修改的:SELECTgame.mdate,game.team1,CASEWHENgoal.teamid=game.team1THEN1ELSE0ENDscore1,game.team2,CASEWHENgoal.teamid=game.team2THEN1ELSE0ENDscore2FROMgame,goalWHEREgam

 teacher表：iddeptnamephonemobile1011Shrivell27530798655512341021Throd27540712255519201031Splint2293 104 Spiregrain3287 1052Cutflower3212079965556574106 Deadyawn3345 dept表：idname1Computing2Design3Engineering1.ListtheteacherswhohaveNULLfortheirdepartment.selectnamefromteacherwheredeptisNULL;2.NotetheIN

 teacher表：iddeptnamephonemobile1011Shrivell27530798655512341021Throd27540712255519201031Splint2293 104 Spiregrain3287 1052Cutflower3212079965556574106 Deadyawn3345 dept表：idname1Computing2Design3Engineering1.ListtheteacherswhohaveNULLfortheirdepartment.selectnamefromteacherwheredeptisNULL;2.NotetheIN