Question: Write a single SQL statement to display the id, first name and last name for directors who have an id in the range of 15

Write a single SQL statement to display the id, first name and last name for directors who have an id in the range of 15 to 50 and either have a first name starting with the letter 'A' or a last name ending with the letter 'Y'.

Write a single SQL statement to display 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!