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 的大作中提到】
: 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 的大作中提到】
: 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.
B*g
7 楼
把他德进球的队员也算上了
1 试着把union 2部分合并
2 b.teamid和c.id不能一样
【在 m******u 的大作中提到】
: the query is not right. too many rows selected.
1 试着把union 2部分合并
2 b.teamid和c.id不能一样
【在 m******u 的大作中提到】
: 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.
相关阅读
关于Fannie Mae的问题请问一下这样的工作在美国叫什么？请教个问题 科华生物 vs biorad请问有人出售GMAT的教材吗？谢谢找financial analyst 或者 consulting 相关工作都有哪些网站？国家外汇管理局和PE这些考试我该考哪个好？直接把CAREER定义在BUSINEES上.还是先打工?诚问前辈经验：polytechnic institute of NYU 的 MBA关于破产法的问题华尔街时代彻底终结了？Equity research analyst opening Buy-sideCredit Analyst是干什么的？需要什么知识？？请问CFA的一二级考试成绩合格有没有有效期啊？中国经济学家吴敬琏否认被国安部调查【NHK最新情报】印度崛起第二部（3）：召回“世界的头脑” ～印侨的力量～请问来美一年transfer需要重考toefl吗Seth Klarman's video on investing生物PhD读个晚上的MBA有用吗？大家给我扫扫盲。3X请教CFA一级notes