Add a new column called Roster Size in SQLite TeamProFinance table that tell how many players are under contract with the Pro and Farm Teams. Can be total for pro in the TeamProFinance and a total for Farm in FarmProFinance also. It is to ouput something like that:
https://www.capfriendly.com/
see Roster Size and Contracts.
thanks.
Roster Size
Re: Roster Size
You can do Select count(*) on players table to achieve what you need.
In database world you never precalculate thing like count, sum, average unless it be in very specific circumstances.
In database world you never precalculate thing like count, sum, average unless it be in very specific circumstances.
-
- STHS Owner / Propriétaire du STHS
- Posts: 14775
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Roster Size
SELECT Count(PlayerInfo.Name) AS CountOfName
FROM PlayerInfo
WHERE (PlayerInfo.Team=1) AND (PlayerInfo.Status1 >=2);
Change the Team for the Team Number and Status for <= 1 if you want farm.
FROM PlayerInfo
WHERE (PlayerInfo.Team=1) AND (PlayerInfo.Status1 >=2);
Change the Team for the Team Number and Status for <= 1 if you want farm.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français