Question: Write a single SQL statement to list the id , first name and last name of all the actors who played in the movie 'Avengers:

Write a single SQL statement to list the id , first name and last name of all the actors who played in the movie 'Avengers: Endgame'.

Write a single SQL statement to list the id ,

Actor Cast PK,FK1 actorld: int PK actorld: int Movie PK movielD : int title : nvarchar(30) year: datetime *PK,FK2 movieID : int firstName: nvarchar(50) lastName: nvarchar(50) gender:nchar (1) role:: nvarchar(20) rank: int Director Movie Director PK,FK1 directorld: int PK directorID: int firstName: nvarchar(50) lastName: nvarchar(50) gender:nchar (1) 11 PK,FK2 movieID: int specialistRole: nvarchar(50)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!