Re: Counting Column With Having Statement

[Peter Brawley]

Is this what you mean?

select count(*) from (
  SELECT count(id) as count 
  FROM users 
  GROUP BY shop_id 
  HAVING count(shop_id) = 2 
) twofers;