This might do the trick
SELECT DATE(rental_date) AS 'Rental date', COUNT(*) AS 'Count' FROM rental GROUP BY DATE(rental_date) ORDER BY COUNT(*) DESC LIMIT 1