STHS Forum

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.

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.

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.