How many payments did LINDA make?
select count(*) from customer as t1 join payment as t2 on t1.customer_id = t2.customer_id group by t1.customer_id where t1.first_name = "LINDA"
Tell me all the information about the largest one.
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 = "LINDA" order by t2.amount desc limit 1
tell me where she lives, and also her email.
select t2.address, t1.email from customer as t1 join address as t2 on t2.address_id = t1.address_id where t1.first_name = 'LINDA'