How many matches were played in the Scottish Premiership division from 2006 to 2008?
Scottish Premiership is a name of division; from 2006 to 2008 means seasons between 2006 and 2008;
SELECT COUNT(T1.Div) FROM matchs AS T1 INNER JOIN divisions AS T2 ON T1.Div = T2.division WHERE T2.name = 'Scottish Premiership' AND (T1.season BETWEEN 2006 AND 2008)