Database: swimming
Question: How many cities have a stadium that was opened before the year of 2006?
SQL:
SELECT count(DISTINCT city) FROM stadium WHERE opening_year  <  2006