m******u
发帖数: 12400 | 1 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 |
|
c*******e
发帖数: 8624 | 2 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' ; |
|
发帖数: 1 | 3 有兴趣的请发简历到: [email protected]/* */
Data Scientist
Data Science Team
About the Job:
We're looking for a great Data Scientist to join Twilio’s Data Science team
. Help us deepen our understanding of our customers’ needs, enhance
Internet-scale products and create fundamentally new kinds of systems, all
informed by your talents in software engineering, exploratory data analysis,
modeling and machine learning.
In this role, you will work with petascale data generated by thousands of
systems an... 阅读全帖 |
|
m******u
发帖数: 12400 | 4 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. |
|
发帖数: 1 | 5 有兴趣的请发简历到: [email protected]/* */
Data Scientist
Data Science Team
About the Job:
We're looking for a great Data Scientist to join Twilio’s Data Science team
. Help us deepen our understanding of our customers’ needs, enhance
Internet-scale products and create fundamentally new kinds of systems, all
informed by your talents in software engineering, exploratory data analysis,
modeling and machine learning.
In this role, you will work with petascale data generated by thousands of
systems an... 阅读全帖 |
|
