bestClients.sql

select sum(amount) as sum,username from Payments
    JOIN Users on Users.id = Payments.client
where state = 'paid' OR state = 'approved'
group by username
order by sum desc 
limit 50;