yes
select distinct city from branch
show me the number of branches of cities
select city, count ( * ) from branch group by city
Count the branches opened before 2010?
select count ( * ) from branch where open_year < 2010
Count  branches opened before 2010 for each city
select city, count ( * ) from branch where open_year < 2010 group by city