Tell me all the information about Lisa's payments.
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 = "Lisa"
What's the largest one among those? Give the payment amount.
select t2.amount from customer as t1 join payment as t2 on t1.customer_id = t2.customer_id group by t1.customer_id where t1.first_name = "Lisa" order by t2.amount desc limit 1
What's the largest one among all the payments?
select amount from payment order by amount desc limit 1