グループの数を数える

×

SELECT COUNT(*) FROM hogelist GROUP BY hid;

○

SELECT COUNT(DISTINCT hid) FROM hogelist;