我正在尝试创建一个sql查询,该查询创建一个具有标题、团队名称、游戏、总分和每场平均分数的联赛表。
对所玩游戏的查询是:选择team_name,从fixtures组中选择team_name(*)作为team_name;
对总分的查询是:选择teams.team_name,COUNT( *)作为total_points_gained从scores、players、teams和players.team_name = teams.team_name组中按teams.team_name
如何将这两个查询组合在一起以获得一个结果中的所有数据?
发布于 2013-11-16 15:43:01
这应该是可行的:
SELECT teams.team_name, COUNT(*) AS total_points_gained,
(SELECT COUNT(*) FROM fixtures WHERE fixtures.team_name = teams.team_name) AS games_played
FROM scores,players,teams
WHERE scores.player_id=players.player_id
AND players.team_name = teams.team_name
GROUP BY teams.team_name发布于 2013-11-16 15:28:42
你应该读读加入的消息。通过连接,您可以将这两个查询(例如,通过team_name )组合成一个结果。
https://stackoverflow.com/questions/20020119
复制相似问题