how many locations have shops that opened before 2008?
select count ( Location )  from shop where Open_Year = '2008'
opened before 2008 refers to Open_Year < 2008; count locations refers to COUNT(DISTINCT Location);