.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 > WinSPMBT > Campaigns, Scenarios & Maps
Notices


 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old March 28th, 2019, 02:10 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
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:
 

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 05:58 AM.


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