Tell me the email of customer with first name PATRICIA.
select email from customer where first_name = "PATRICIA"
Tell me all the information about the payments they made.
select * from customer as t1 join payment as t2 on t1.customer_id = t2.customer_id group by t1.customer_id where t1.first_name = "PATRICIA"
tell me which customer, who has made at least one payment, has spent the least money. List his or her first name, last name, and the id.
select t1.first_name, t1.last_name, t1.customer_id from customer as t1 join payment as t2 on t1.customer_id = t2.customer_id group by t1.customer_id order by sum(amount) asc limit 1