找出旅客中出现次数最多的名字 - SQL 查询教程

找出旅客中出现次数最多的名字是什么

查询结果 显示“名字、次数”内容：SELECT pname, COUNT() AS count FROM passenger GROUP BY pname HAVING count = (SELECT MAX(count) FROM (SELECT pname, COUNT() AS count FROM passenger GROUP BY pname) AS T)