SELECT city ,  count(*) FROM branch WHERE open_year  <  2010 GROUP BY city
For each city, how many branches opened before 2010?
SELECT city , count ( * ) FROM branch WHERE open_year < 2010 GROUP BY city
select city , count ( * ) from branch where open_year < value group by city
For each city , how many branches opened before 2010 ?