Which cities have 2 to 4 parks?
select city from park group by city having count ( * ) between 2 and 4
How many parks are in Atlanta?
select count ( * ) from park where city = "Atlanta"
Which cities have exactly 4 parks?
select city from park group by city having count ( * ) = 4
Which cities have exactly 3 parks?
select city from park group by city having count ( * ) = 3
Which cities have exactly 2 parks?
select city from park group by city having count ( * ) = 2