Using the example code I have provided, insert a new record into the player table for Team Gandalf.

team$\_$id $=1$

Using the example code I provided, execute a select query to display the player records $($I want to verify the record was inserted successfully$).$

This query should include the INNER JOIN; I want to see the team$\_$name field and not the team$\_$id in the output window.

Using the example code I provided, update the newly inserted record by changing the player's team to Team Sauron.

team$\_$id $=2$

Using the example code I provided, execute a select query to display the updated record.

This query should include the INNER JOIN; I want to see the team$\_$name field and not the team$\_$id in the output window.

Using the example code I provided, execute a delete query to remove the updated record.

Using the example code I provided, execute a select query to display all the records in the player table.

This query should include the INNER JOIN; I want to see the team$\_$name field and not the team$\_$id in the output window.