mysql - 试图弄清楚如何找到最大计数

Question

Which team has the most number of members on their roster?

好的，下面是我目前输入的代码。它返回所有团队以及每个团队中有多少人。我不确定如何对其进行编码以仅显示成员最多的团队，因为当我尝试使用最大函数和计数函数时出现错误。

SELECT Team_Name, COUNT(Member.Student_ID_Num) 
FROM Teams 
JOIN Member ON Teams.Team_Number = Member.Team_Number 
GROUP BY Team_Name

Answer 1

您可以尝试以下 - 使用 limit 和 order by desc

Select Team_Name, count(Member.Student_ID_Num) as cnt
from Teams join Member on Teams.Team_Number = Member.Team_Number 
group by Team_Name
order by cnt desc
limit 1