[zovs66]

Once the 2019 patch is out, with the CD version of ScenHack you get quite a lot of useful and powerful tools at your disposal, not only for Scenario Designers, but for players as well.

There is a host of SQL in the "SQL" folder (for both games) and I helped create these SQL so that both players and Designers can query the databases and find some interesting information.

For a small example, here is a listing of all the USMC scenarios sorted by year and month where the USMC is Player One (USMC-Player-1-Scenarios-by-Year-Month.sql):

499 Wilkes Island, Wake, 23 Dec 1941	12	1941	USMC	Japan
500 Tanambogo Islet, 8 Aug. 1944	8	1942	USMC	Japan
050 Into The Valley 10/42		10	1942	USMC	Japan
512 Lambeti Plantation			6	1943	USMC	Japan
625 Raider Ridge 6/43			6	1943	USMC	Japan
049 Stark and Bitter Hours 11/43	11	1943	USMC	Japan
492 Tarawa Atoll, Nov. 1943		11	1943	USMC	Japan
513 Tarawa's Crimson Tides 1943		11	1943	USMC	Japan
073 Return to Guam 7/44			7	1944	USMC	Japan
501 Guam, Marianas, 21 Jul. 1944	7	1944	USMC	Japan
401 Peleliu #1, D-Day 0530-0930		9	1944	USMC	Japan
402 Peleliu #2, D-Day South 0930-1800	9	1944	USMC	Japan
403 Peleliu #3, D-Day North 0930-1800	9	1944	USMC	Japan
404 Peleliu #4, D+1, South area		9	1944	USMC	Japan
405 Peleliu #5, D+1 North area		9	1944	USMC	Japan
502 The 1,000 Yard Stare		10	1944	USMC	Japan
503 Split Down the Middle		10	1944	USMC	Japan
063 Iwo Jima: First Ashore 2/45		2	1945	USMC	Japan
064 Iwo Jima: Sever The Head 2/45	2	1945	USMC	Japan
065 Iwo Jima: Take Suribachi 2/45	2	1945	USMC	Japan
066 Iwo Jima: The Meat Grinder 2/45	2	1945	USMC	Japan
457 Iwo Jima  D-Day 2/1945		2	1945	USMC	Japan
495 A Common Virtue, Feb. 1945		2	1945	USMC	Japan
518 Charlie Dog Ridge, 25 Feb 1945	2	1945	USMC	Japan
067 Iwo Jima:  Last Gasp 3/45		3	1945	USMC	Japan
710 On China Station 7/46		7	1946	USMC	Chinese Communists

So currently (as of 3/27/2019) there are a total of 26 scenarios where the USMC is player one.

Here is the query I used to get that total:

SELECT COUNT(*) AS Total
FROM ScenData.db
WHERE P1Name = "USMC"

Here is the "default" (USMC-Player-1-Count-by-Year.sql) query that is included for the total count of USMC scenarios by year:

USMC	Japan			1941	1
USMC	Japan			1942	2
USMC	Japan			1943	5
USMC	Japan			1944	9
USMC	Japan			1945	8
USMC	Chinese Communists	1946	1

Pretty cool huh?

If you have any questions about the SQL's ask me, most standard queries should work.