What is the total amount paid for rentals made on July 29, 2005?
July 29, 2005 refers to rental_date like '2005-07-29'
SELECT SUM(T2.amount) FROM rental AS T1 INNER JOIN payment AS T2 ON T1.rental_id = T2.rental_id WHERE date(T1.rental_date) = '2005-07-29%'