m*u
2 楼
show the name of all players who scored a goal against Germany?
table 1: game: columns (id, mdate, stadium, team1, team2)
table 2: goal: columns(matchid, teamid, player, grime)
table 3: eteam: columns (id, teamname, coach)
其中
game.id = goal.matchid
game.team1 (and team2) = eteam.id = goal.teamid
table 1: game: columns (id, mdate, stadium, team1, team2)
table 2: goal: columns(matchid, teamid, player, grime)
table 3: eteam: columns (id, teamname, coach)
其中
game.id = goal.matchid
game.team1 (and team2) = eteam.id = goal.teamid
s*n
3 楼
1.免费的100刀 Chase SapphireSM Card 只需消费一笔
http://creditcardbonus.spaces.live.com/blog/
最近申请chase家的这个信用卡会弹出一个页面,写着Before you go…We hope you
will reconsider 难不成他们家最近被人拿太多这个100刀了! 不用对它客气,赶
紧点击Return&Apply, 拿到落袋为安。
http://creditcardbonus.spaces.live.com/blog/
2. 免费的250刀 Chase SapphireSM Preferred Card需要满足这个offer的条件 优先
考虑哈 里面有指导如何满足条件
http://creditcardbonus.spaces.live.com/blog/
3. Free $75 Cashback Bonus from Discover More® Card 最适合中美间使用的
多彩卡片Discover信用卡 而且现在连续三个月消费一定笔数还送额外60刀
http://credit
http://creditcardbonus.spaces.live.com/blog/
最近申请chase家的这个信用卡会弹出一个页面,写着Before you go…We hope you
will reconsider 难不成他们家最近被人拿太多这个100刀了! 不用对它客气,赶
紧点击Return&Apply, 拿到落袋为安。
http://creditcardbonus.spaces.live.com/blog/
2. 免费的250刀 Chase SapphireSM Preferred Card需要满足这个offer的条件 优先
考虑哈 里面有指导如何满足条件
http://creditcardbonus.spaces.live.com/blog/
3. Free $75 Cashback Bonus from Discover More® Card 最适合中美间使用的
多彩卡片Discover信用卡 而且现在连续三个月消费一定笔数还送额外60刀
http://credit
c*e
4 楼
select b.player
from game a
join goal b
on a.id = b.matchid
join eteam c
on a.team1 = c.id
and c.teamname = 'Germany'
union
select b.player
from game a
join goal b
on a.id = b.matchid
join eteam c
on a.team2 = c.id
and c.teamname = 'Germany' ;
【在 m******u 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: show the name of all players who scored a goal against Germany?
: table 1: game: columns (id, mdate, stadium, team1, team2)
: table 2: goal: columns(matchid, teamid, player, grime)
: table 3: eteam: columns (id, teamname, coach)
: 其中
: game.id = goal.matchid
: game.team1 (and team2) = eteam.id = goal.teamid
from game a
join goal b
on a.id = b.matchid
join eteam c
on a.team1 = c.id
and c.teamname = 'Germany'
union
select b.player
from game a
join goal b
on a.id = b.matchid
join eteam c
on a.team2 = c.id
and c.teamname = 'Germany' ;
【在 m******u 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: show the name of all players who scored a goal against Germany?
: table 1: game: columns (id, mdate, stadium, team1, team2)
: table 2: goal: columns(matchid, teamid, player, grime)
: table 3: eteam: columns (id, teamname, coach)
: 其中
: game.id = goal.matchid
: game.team1 (and team2) = eteam.id = goal.teamid
m*u
5 楼
thanks
m*u
6 楼
the query is not right. too many rows selected.
m*u
8 楼
one more. Thanks.
Show the stadium and the number of goals scored in each stadium.
Show the stadium and the number of goals scored in each stadium.
m*u
9 楼
thanks, Beijing
m*u
10 楼
if I want to show game id, stadium and the name of the two teams (basically
it is the game table, just in game table the two teams are showed in teamid)
. I need use the game table to join the eteam table twice. Am I correct here
. Thanks.
it is the game table, just in game table the two teams are showed in teamid)
. I need use the game table to join the eteam table twice. Am I correct here
. Thanks.
相关阅读
Financial Engineering Seminarsmean/ std请问CFA报名之后会有书寄来么?请问有人知道哪里可以下载CFA 1的notes?做quant的职业发展一般是什么样的路?buyside到底有多好?career 问题:去Wall Street和在硅谷做软工, 哪个好 ?有人在准备CapGemini或者Deloitte的面试么?小测验,概率题,夫妻两个在黑暗中摸球,经济学硕士找工作难易程度如何?谁说说facebook为啥这么nb,未明这么弱阿.Re: 技术探讨一下,关于送老婆读名校MBA (转载)请问银行类通常要求的serieson line MBA program贴一下我们公司HR感兴趣的MBA学校请问大家生物phd读management的master找工作有用吗有经验的来帮我看看finance目前的前景潘石屹要上市MFE or MBA 有经验的前辈给看看Wharton EMBA interview