Question: this question is generated from table one and 2 that i submit Display the rental transaction ID, member ID, the number of weeks between the

this question is generated from table one and 2 that i submit

Display the rental transaction ID, member ID, the number of weeks between the movie rent date and return date (call this column "Delay_weeks", use "December 1, 2009" as the return date if a movie's return date is not yet available). The values in the column should be rounded to integers. Please also display another new column with the name "status" that shows whether the movie in each rental transaction was "Returned" or Not Returned". Display the rental transaction ID, member ID, the number of weeks between the movie rent date and return date (call this column "Delay_weeks", use "December 1, 2009" as the return date if a movie's return date is not yet available). The values in the column should be rounded to integers. Please also display another new column with the name "status" that shows whether the movie in each rental transaction was "Returned" or Not Returned
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
