Here is a query that produces total number of scenarios by year:
Code:
SELECT sYear, count(*) AS Total
FROM ScenData.db
WHERE (sMonth > 0 AND sYear > 0) AND ScenID !=999
GROUP BY sYear
ORDER BY Total DESC
Here is the top 10 (so to speak):
Code:
sYear Total
1989 39
1985 38
1984 29
1973 22
2009 21
1950 18
1967 15
1982 15
2015 12
2020 12
1968 11
1991 11
2006 10
2005 10
1965 10
1979 10
1978 10
2003 10