Question
create a query to write list of all actors who played in a movie called AMADEUS HOLY. SELECT f.title AS FilmTitle, CONCAT(last_name, ', ',
create a query to write list of all actors who played in a movie called "AMADEUS HOLY".
SELECT f.title AS FilmTitle, CONCAT(last_name, ', ', first_name) AS ActorName FROM film f JOIN film_actor fa ON f.film_id = fa.film_id JOIN actor a ON fa.actor_id = a.actor_id WHERE title = 'AMADEUS HOLY';
Step by Step Solution
3.42 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
SELECT ActorsActorName FROM Actors INNER ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Using Microsoft Excel and Access 2016 for Accounting
Authors: Glenn Owen
5th edition
1337109048, 1337109045, 1337342149, 9781337342148 , 978-1337109048
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App