SELECT count(*) FROM club WHERE clublocation  =  "HHH"
Count the number of clubs located at "HHH".
SELECT count ( * ) FROM club WHERE clublocation = `` HHH ''
select count ( * ) from club where clublocation = value
Count the number of clubs located at `` HHH '' .