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
1 Expert Approved Answer
Step: 1 Unlock
SELECT ActorsActorName FROM Actors INNER ... View full answer
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
