SELECT count(DISTINCT city) FROM stadium WHERE opening_year  <  2006
How many cities have a stadium that was opened before the year of 2006?
SELECT count ( DISTINCT city ) FROM stadium WHERE opening_year < 2006
select count ( distinct city ) from stadium where opening_year < value
How many cities have a stadium that was opened before the year of 2006 ?