Question: Write a single SQL statement to display the id, first name and last name for actors whose full name (first name and last name) contains

Write a single SQL statement to display the id, first name and last name for actors whose full name (first name and last name) contains fewer than 30 characters. Assume that column last name allows NULL.

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!