Using the Sakila database, create a query that displays the film title, description, as well the actor first and last name for all films that begin with the letters 'zo'.

Question

Computers & Technology

Greyson Abbott

7 April, 12:48

Using the Sakila database, create a query that displays the film title, description, as well the actor first and last name for all films that begin with the letters 'zo'.

+3

Answers (1)

Know the Answer?

Dulce Henry · Answer 1

Select title, description, first_name, last_name from film inner join film_actor on film. film_id = film_actor. film_id inner join actor on film_actor. actor_id = actor. actor_id where title LIKE 'zo%';

Explanation:

The INNER JOIN keyword selects records that have matching values in both tables. The WHERE clause is used to filter records. The WHERE clause is used to extract only those records that fulfill a specified condition.