get the 10 customers with the most payments

            
              
            
            SELECT c.customer_id, c.first_name, c.last_name, COUNT(p.payment_id) AS num_payments
FROM customer_list cl 
INNER JOIN customer c ON cl.id = c.customer_id
INNER JOIN payment p ON c.customer_id = p.customer_id
GROUP BY c.customer_id, c.first_name, c.last_name
ORDER BY num_payments DESC
LIMIT 10;