SQL CODE
Late rental movie store
SELECT
customer_id,
rental_id,
movie_title,
DATEDIFF(CURRENT_DATE, return_due_date) as days_overdue
FROM
rentals
WHERE
return_status = 'Checked Out'
AND DATEDIFF(CURRENT_DATE, return_due _date) > 0;
Late rental movie store
SELECT
customer_id,
rental_id,
movie_title,
DATEDIFF(CURRENT_DATE, return_due_date) as days_overdue
FROM
rentals
WHERE
return_status = 'Checked Out'
AND DATEDIFF(CURRENT_DATE, return_due _date) > 0;