all are part of one question use sql pls

mysql> SELECT FROM production; Using only one UPDATE statement, update the table movie to insert values for prod_id for all the movies. The production companies for the movies are listed below. Note: you are inserting only the prod_id in the table movie, not the production companies' names. You'll need to look in the table production to find the id for each production company (you can see the id's in the answer for #5). Hint: CASE (just like the example from the video). Take a screenshot now and paste it here. Add a foreign key constraint to the movie table: the column prod_id is the foreign key, referencing the column id from the production table. Take a screens hot now and paste it here. Show the structure of your table movie. Take a screenshot now and paste it here. Insert the following data in your database. You will need to use more than one INSERT statement. Hints: You will need to add data to both tables. Remember that the movie table has the id of the production co., not the name