What is the customer id that spends the most
select customer_id from payments group by customer_id order by sum ( amount_paid ) desc limit 1
For that Customer with ID 12, what was the amount they spend?
select sum ( amount_paid ) from payments where customer_id = 12
What was the payment type of customer with ID 12?
select payment_type_code from payments where customer_id = 12