mysql> SELECT shohin_bunrui,COUNT(*) FROM Shohin GROUP BY shohin_bunrui HAVING COUNT(*)=2;
SELECT shohin_bunrui ,COUNT(*) FROM Shohin GROUP BY shohin_bunrui;
SELECT shohin_bunrui,COUNT(*) FROM Shohin GROUP BY shohin_bunrui HAVING shohin_bunrui = '办公用品';
WHERE 行对应的条件
HAVING 组对应的条件