Write SQL query to solve given problem: List the films' titles which were rented on 24th May,2005.. Keep the solution inside sql tag ```sql [SQL-Query] ```
SELECT T1.title FROM film AS T1 INNER JOIN inventory AS T2 ON T1.film_id = T2.film_id INNER JOIN rental AS T3 ON T2.inventory_id = T3.inventory_id WHERE SUBSTR(T3.rental_date, 1, 10) = '2005-05-24'