Question

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'.

Answer 1

Answer:

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.