Question: Using Sakila Database Insert a rental record for Customer Rodney Moeller renting the movie Panic Club from store 1 . Use the lowest inventory id
Using Sakila Database Insert a rental record for Customer Rodney Moeller renting the movie "Panic Club" from store Use the lowest inventory id that isn't checked out. Set the rental date and last update to and use staffid The rentalid will be autogenerated by the database if you create your insert statement correctly. Put your answer in Qsql
Insert a payment for the rental you inserted with the query in question the amount of the payment should be $ The rental id generated by the database should be The rest of the information should match the rental information from question Put your answer in Qsql Update all outstanding rentals to have a return date of Put your answer in Qsql
Delete the payment you inserted in question Put your answer in Qsql
Delete the rental you inserted in question Put your answer in Qsql
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
