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

Not too surprisingly here is the list:

sYear	Total
1944	199
1945	114
1941	109
1943	100
1942	91
1940	75
1939	57
1936	6
1938	6
1937	5
1934	4
1935	3
1946	2
1933	2
1932	1
1931	1
1930	1

* Note: I excluded out the twenty-five 1930 scenario's (real dates 1908-1929) I am currently working for this result.