Show the city and the number of branches opened before 2010 for each city
select city, count ( * ) from branch where open_year < 2010 group by city
Which year were those branches opened?
select open_year from branch where open_year < 2010
Give me names of branches opened before 2010
select name from branch where open_year < 2010