Using the 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 $\text{'}2023-05-05\text{'}$ 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 Q$01.$sql

Insert a payment for the rental you inserted with the query in question $1$ the amount of the payment should be $$4\mathrm{.}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 Q$02.$sql

Insert a new address with the following information: address $-112$ N Pole Ln$,$ district $-$ Ontario, city id $-388,$ postal code $-38233,$ phone $-2225551221,$ last update $-2023-05-05.$ The address id should be autogenerated by the database and all other fields should be null. Put your answer in Q$03.$sql

Insert a new customer with the following information: store id $-2,$ first name $-$ Santa, last name $-$ Claus, email $-$ santa.claus@sakilacustomer.org, address $-606,$ active $-1,$ last update and create date $-\text{'}2023-05-05\text{'}.$ Put your answer in Q$04.$sql

Update address $606$ to $122$ North Pole ln$.$ Don't forget to change the last update to the current date. Put your answer in Q$05.$sql

Update all outstanding rentals to have a return date of $\text{'}2023-05-08\text{'}.$ Put your answer in Q$06.$sql

Delete the payment you inserted in question $2.$ Put your answer in Q$07.$sql

Delete the rental you inserted in question $1.$ Put your answer in Q$08.$sql

Delete Santa's customer record. Put your answer in Q$09.$sql

Delete address $606.$ Put your answer in Q$10.$sql

Uuu