.com.unity Forums
  The Official e-Store of Shrapnel Games

This Month's Specials

Raging Tiger- Save $9.00
winSPMBT: Main Battle Tank- Save $6.00

   







Go Back   .com.unity Forums > The Camo Workshop > WinSPWW2
Notices


 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old March 28th, 2019, 02:13 PM
zovs66's Avatar

zovs66 zovs66 is offline
First Lieutenant
 
Join Date: Mar 2011
Location: Ohio
Posts: 788
Thanks: 1,258
Thanked 576 Times in 313 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
Not too surprisingly here is the list:

Code:
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.
__________________
ASL
Reply With Quote
The Following User Says Thank You to zovs66 For This Useful Post:
 

Bookmarks


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT -4. The time now is 12:45 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©1999 - 2024, Shrapnel Games, Inc. - All Rights Reserved.