how many locations have shops that opened before 2008?
select count ( location ) from shop where open_year = '2008'
how many shops opened later than 2012?
select count ( location ) from shop where open_year>'2012'
can you show the locations for those stores?
select location from shop where open_year>'2012'