players: Username, Gang, Cash, Bank
gang: gangId, gangName

select g.gangid,
       count(p.username) as total_members,
       sum(cash+bank) as total_wealth
from gang g
left join players p on p.gang = g.gangid
group by g.gangid

SELECT p.gang, count(gang)
    FROM players p
    GROUP BY p.gang