SELECT currency_id, COUNT(*) AS "Count" FROM tablea WHERE currency_id = 0 GROUP BY currency_id HAVING COUNT(*) >= 3;
[注意]
（完）
mysql-group by 与 where
原文：https://www.cnblogs.com/lishidefengchen/p/13271764.html
