For the following questions, use the movie database structure as a reference
1. Write a SELECT statement to retrieve all actors for the movie with the id of 143532. The actors names should be formatted as lastname, firstname
2. Write a SELECT statement to retrieve all titles and artists for songs found in the movie with the id of 453632. Order the results by artist name.
3. If Paul Newman's id in the people table is 21435, write a SELECT statement that will retrieve the the title and synopsis for all the movies where Paul Newman appeared as an actor. 4. Roger Ebert's id in the critics table is 45. Write a SELECT statement to retrieve all the titles of movies that have reviews by Roger Ebert.

Answer rating: 100% (QA)

1 Initialize three in... View the full answer