Interesting Query Results

[zovs66]

Here is a query that produces total number of scenarios by year:

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):

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