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 1. Use the lowest inventory id that isn't checked out. Set the rental date and last update to '2023-05-05' and use staff_id 1. The rental_id will be autogenerated by the database if you create your insert statement correctly. Put your answer in Q01.sql
Insert a payment for the rental you inserted with the query in question 1 the amount of the payment should be $4.99. The rental id generated by the database should be 16050. The rest of the information should match the rental information from question 1. Put your answer in Q02.sql Update all outstanding rentals to have a return date of '2023-05-08'. Put your answer in Q06.sql
Delete the payment you inserted in question 2. Put your answer in Q07.sql
Delete the rental you inserted in question 1. Put your answer in Q08.sql

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!