View Single Post
  #1  
Old March 28th, 2019, 02:10 PM
zovs66's Avatar

zovs66 zovs66 is online now
Second Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 493
Thanks: 468
Thanked 348 Times in 172 Posts
zovs66 is on a distinguished road
Default Interesting Query Results

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
__________________
ASL
Reply With Quote
The Following 2 Users Say Thank You to zovs66 For This Useful Post: