In this lab, you will be using the Sakila database of movie rentals. You have been using this database for a couple labs already, but if you need to get the data again, refer to the official installation link.
The database is structured as follows:
- Drop column
picture
fromstaff
. - A new person is hired to help Jon. Her name is TAMMY SANDERS, and she is a customer. Update the database accordingly.
- Add rental for movie "Academy Dinosaur" by Charlotte Hunter from Mike Hillyer at Store 1 today.
- Delete non-active users, but first, create a backup table
deleted_users
to storecustomer_id
,email
, and thedate
the user was deleted.