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;