ASP源码.NET源码PHP源码JSP源码JAVA源码DELPHI源码PB源码VC源码VB源码Android源码
当前位置:首页 >> 数据库 >> 其他数据库 >> sqlzoo练习答案--The JOIN operation

sqlzoo练习答案--The JOIN operation(1/5)

来源:网络整理     时间:2016-01-13     关键词:

本篇文章主要介绍了"sqlzoo练习答案--The JOIN operation",主要涉及到方面的内容,对于其他数据库感兴趣的同学可以参考一下: gameidmdatestadiumteam1team210018 June 2012National Stadium, WarsawPOLGRE10028 J...

game
idmdatestadiumteam1team2
10018 June 2012National Stadium, WarsawPOLGRE
10028 June 2012Stadion Miejski (Wroclaw)RUSCZE
100312 June 2012Stadion Miejski (Wroclaw)GRECZE
100412 June 2012National Stadium, WarsawPOLRUS
...
goal
matchidteamidplayergtime
1001POLRobert Lewandowski17
1001GREDimitris Salpingidis51
1002RUSAlan Dzagoev15
1001RUSRoman Pavlyuchenko82
...
eteam
idteamnamecoach
POLPolandFranciszek Smuda
RUSRussiaDick Advocaat
CZECzech RepublicMichal Bilek
GREGreeceFernando Santos
...

1、The first example shows the goal scored by a player with the last name 'Bender'. The * says to list all the columns in the table - a shorter way of saying matchid, teamid, player, gtime

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

相关图片

相关文章