Table 1: actor_movie
Actors who appeared in a movie.
col_name | col_type ------------+------------------- actor_id | integer first_name | character varying last_name | character varying
Question 48
Movie and TV actors
Instruction
- Write a query to return actors who appeared in both tv and movies
- The order of your results doesn't matter.
- You need to use
INNER JOIN.
Table 2: actor_tv
Actors who appeared in a TV show.
col_name | col_type ------------+------------------- actor_id | integer first_name | character varying last_name | character varying
Sample results
actor_id | first_name | last_name
----------+-------------+-------------
1 | PENELOPE | GUINESS
4 | JENNIFER | DAVIS
Solution
postgresSELECT
M.actor_id,
M.first_name,
M.last_name
FROM actor_movie M
INNER JOIN actor_tv T
ON T.actor_id = M.actor_id;Explanation
This query selects the actor ID, first name, and last name from two tables: "actor_movie" and "actor_tv". It then joins these two tables on the "actor_id" column to only show actors who have worked in both movies and TV shows.
Copied
Last Submission
postgresNo submission yet for this engine. Run and submit your query to save it here.
Copied
Expected results
Submit a query to compare against expected output.
Postgres
Interview timer
Recommended interview pacing
Easy: 5 min for direct warm-up style questions.
Medium: 10 min for multi-step interview queries.
Hard: 15 min for layered questions with tighter time pressure.
A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.
5:00
Your results
Run your query to preview results here.