对XX国,YY国分别统计其购买最大数量的用户
bc bc1表为统计各个用户的购买量
SELECT bc1.*
FROM
(
SELECT buyer_country_id,buyer_admin_id,COUNT(0) buycount
FROM train_9
GROUP BY buyer_admin_id
) bc1
WHERE bc1.buycount=
(
SELECT MAX(bc.buycount)
FROM
(
SELECT buyer_country_id,buyer_admin_id,COUNT(0) buycount
FROM train_9
GROUP BY buyer_admin_id
) bc
WHERE bc1.buyer_country_id = bc. buyer_country_id
)
参考方法:https://blog.csdn.net/yige9394/article/details/79481706