SELECT 
    o.id AS pkg_idx,
    o.title AS pkg_title,
    o.descriptor AS pkg_descriptor,
    ( SELECT SUM(x.balance) FROM payments p LEFT JOIN players x ON x.id=p.owner WHERE p.pkgnum=o.id) AS total_balance,
    ( SELECT COUNT(*) FROM payments p LEFT JOIN players x ON x.id=p.owner WHERE p.pkgnum=o.id) AS total_players,
    ( SELECT SUM(x.balance)/COUNT(*) FROM payments p LEFT JOIN players x ON x.id=p.owner WHERE p.pkgnum=o.id) AS avg_balance
FROM fb_credits o