How many parks does each state have?
select state, count(*) from park group by state
Which states have more than 3 parks?
select state from park group by state having count(*) > 3;
Which states have more than 2 parks?
select state from park group by state having count(*) > 2;