Wqrld · March 3, 2023 13:04
diff --git a/bestClients.sql b/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;
	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;