sql add values if has same location value code example

Example: Having trouble running COUNT in my INSERT INTO statement

ROW_NUMBER() OVER(ORDER BY tblPlayers.PlayerID) AS TransactionID