select a.G_Name as 行会,a.G_Master as 盟主,人数=b.[Count]
from Guild as a inner join (
SELECT DISTINCT(G_Name) as G_Name,COUNT(1) AS [Count]
FROM GuildMember
group by G_Name
) as b on a.G_Name=b.G_Name
order by b.[Count] desc
from Guild as a inner join (
SELECT DISTINCT(G_Name) as G_Name,COUNT(1) AS [Count]
FROM GuildMember
group by G_Name
) as b on a.G_Name=b.G_Name
order by b.[Count] desc
SELECT DISTINCT(G_Name) as G_Name,Name
FROM GuildMember
from Guild as a
inner join GuildMember as b on a.G_Name=b.G_Name
group by a.G_Name,a.G_Master
order by 人数 desc