Totals for 2021 - 2026 (2021-2023 atill to be added)

select p_name,sum(p_sort) as tot,sum(p_played) as played, sum(p_cash) as cash, sum(p_b_cash) as b_cash, sum(p_w) as wins, sum(p_wt) as tied, sum(p_l) as lost, sum(p_s) as strong, sum(p_b) as bird from players where p_played > 0 group by p_id


P WW TLSCashBirdB CashTotal
David135293976£-59.0062£-35.00£-94.00
Malcolm3990264£-17.5024£-0.50£-18.00
Richard97544372£76.5067£19.00£86.50
Robbie99393543£23.5093£32.50£56.00
Steve2420157£-23.5011£-7.00£-30.50