Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Microsoft Excel and Access 2016 for Accounting

Authors: Glenn Owen

5th edition

1337109048, 1337109045, 1337342149, 9781337342148 , 978-1337109048

More Books

Students also viewed these Databases questions

Question

What is an access control list?

Answered: 1 week ago

Question

How do you change the name of a sheet in a workbook?

Answered: 1 week ago

Question

Which ratios are usually formatted as numbers?

Answered: 1 week ago