SQL exercises on movie Database: Find the cast list for the movie Chinatown

SQL movie Database: Join Exercise-19 with Solution

19. From the following tables, write a SQL query to find the cast list of the movie ‘Chinatown’. Return first name, last name.

Sample table: movie

Sample table: movie_cast

Sample table: actor

Sample Solution:

SELECT a.act_fname, a.act_lname
FROM
movie_cast c
JOIN actor a ON
c.act_id = a.act_id
Where mov_id = (
SELECT mov_id
FROM movie
Where mov_title = 'Chinatown');

Sample Output:

      act_fname       |      act_lname
----------------------+----------------------
 Jack                 | Nicholson
(1 row)

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following tables, write a SQL query to find those actors who have directed their movies. Return actor first name, last name, movie title and role.
Next: From the following tables, write a SQL query to find those movies where actor’s first name is 'Harrison' and last name is 'Ford'. Return movie title.