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 submitDisplay the rental transaction ID, member ID, the number of weeks betweenthis question is generated from table one and 2 that i submit

the movie rent date and return date (call this column "Delay_weeks", use

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!