How many branches are there?
select count(*) from branch
What about before 2010?
select count(*) from branch where open_year < 2010
Can you show me those for each city?
select city, count(*) from branch where open_year < 2010 group by city