What is the maximum total amount paid by a customer? List the customer id and amount.
SELECT customer_id ,  sum(amount_paid) FROM Payments GROUP BY customer_id ORDER BY sum(amount_paid) DESC LIMIT 1
maximum total amount paid by a customer refers to MAX(SUM(amount_paid)); list customer id and amount refers to SELECT customer_id, SUM(amount_paid);