MySQL旅客数据统计：姓氏人数和最常见名字

SELECT SUBSTRING_INDEX(full_name, ' ', 1) AS last_name, COUNT() AS passenger_count FROM passengers GROUP BY last_name; SELECT first_name, COUNT() AS name_count FROM passengers GROUP BY first_name ORDER BY name_count DESC LIMIT 1;