Using Java

Run the following queries:

Write a query that Inserts a new actor into the database. Once you have completed the insert, write a query to view all information for that specific actor.

Write a query to Update the actor that you just inserted. Give your new actor a first$\_$name of Emmy and a last$\_$name of Rock. When you have completed that update, run another query to see your updated employee.

Tip! Make sure only to update your specific employee. Don't update all employees!

Write a query that finds all staff that do not have a value specified for password.

Write a query that finds all staff's information that has a value for first$\_$name and store$\_$id$.$

Write a query that updates all people with a Null value in the address$2$ column. If the district is Alberta, put address$2$ as Canada, and if the district is QLD$,$ put Australia.