大佬教程收集整理的这篇文章主要介绍了获取球队和城市的球员数量，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。
SELECT COUNT(*),city
FROM Team t INNER JOIN Player p
ON t.name=p.team
GROUP BY city
City,number of player in city
A,10
B,5
C,15
SELECT COUNT(*),team
FROM Player
GROUP BY team
Team,number of player in team
A1,5
A2,2
A3,3
B1,2
B2,3
C1,15
City,Team,number of player in team,A1,5,10
A,A2,2,A3,3,B1,5
B,B2,C1,15,15
with PlayerCountByCity as
(
SELECT t.City,COUNT(*) as CityPlayerCount
FROM Team t INNER JOIN Player p
ON t.name=p.team
GROUP BY t.City
),PlayerCountByTeam as
(
SELECT t.City,p.Team,COUNT(*) as TeamPlayerCount
FROM Team t inner join Player p
on t.name=p.team
GROUP BY t.City,t.Team
)
SELEct a.City,b.Team,b.TeamPlayerCount,a.CityPlayerCount
from PlayerCountByCity a inner join PlayerCountByTeam b on a.City=b.City
SELEct a.City,c.Team,c.TeamPlayerCount,b.CityPlayerCount
from City a left join PlayerCountByCity b on a.City=c.City
left join PlayerCountByTeam c on a.City=c.City
以上是大佬教程为你收集整理的获取球队和城市的球员数量全部内容，希望文章能够帮你解决获取球队和城市的球员数量所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。