Database: products_for_hire
Question: What are the id and the amount of refund of the booking that incurred the most times of payments?
SQL:
SELECT T1.booking_id ,  T1.amount_of_refund FROM Bookings AS T1 JOIN Payments AS T2 ON T1.booking_id  =  T2.booking_id GROUP BY T1.booking_id ORDER BY count(*) DESC LIMIT 1