- To generate a table showing the movie titles and director names, what tables do you need?
Movies and Actors.
- What is the SQL code for "Movie Titles and Directors" query?
- What tables do you need to generate a query that displays movie titles, their scores, and the director of those movies?
Movies(titles, scores) and actors (name).
- Generate a query named "Movies and Directors by Score" that only displays titles, scores, and the director for each movie sorted by the movie's score from highest to lowest. Copy and paste the movies with a score of 9 or higher.
Note: you can sort a data field (as ascending or descending) on the Query Design View.
Movies Запрос | ||
Title | Score | Name |
Wo huzang long | Ang Lee | |
Shichinin no samurai | Akira Kurosawa | |
Shawshank Redemption, The | Frank Darabont | |
Godfather, The | Francis Ford Coppola |
e. Display the SQL used to generate "Movies and Directors by Score" query.
- What tables do you need to generate a query that shows movies and the actors who played in the movies?
Movies(titles) and Actors (name).
- Below is the result of the query "Movie Titles and Actors". Examine the query result and describe the data that is actually generated. Does the table represent movies and the actors in the movies? If not, describe what data is shown in the table.
Figure 3 Movie Titles and Actors Titles of movies and name of actors. |
- The SQL code used to generate the incorrect "Movie Titles and Actors" query is as follows: