SELECT pname count FROM passengerGROUP BY pname 修改成统计每个姓氏的旅客人数

SELECT SUBSTRING_INDEX(pname, ' ', 1) as surname, count(*) FROM passenger GROUP BY surname

原文地址: http://www.cveoy.top/t/topic/h8wg 著作权归作者所有。请勿转载和采集!