Using GROUP BY instead of HAVING

group.sql

SELECT icps.city, icps.state, icps.ice_cream_parlor
FROM ice_cream_parlors icps
INNER JOIN (
                SELECT city, state, count(ice_cream_parlor) icp_count
                FROM ice_cream_parlors icps
                GROUP by city, state
           ) sq
ON icps.city = sq.city and icps.state = sq.state
GROUP BY icps.city, icps.state, icps.ice_cream_parlor
WHERE sq.icp_count > 5;