Table 1: actor
col_name | col_type -------------+-------------------------- actor_id | integer first_name | text last_name | text
Question 36
Actors from film 'AFRICAN EGG'
Instruction
- Write a query to return the first name and last name of all actors in the film 'AFRICAN EGG'.
- The order of your results doesn't matter.
Table 2: film
col_name | col_type ----------------------+-------------------------- film_id | integer title | text description | text release_year | integer language_id | smallint original_language_id | smallint rental_duration | smallint rental_rate | numeric length | smallint replacement_cost | numeric rating | text
Table 3: film_actor
Films and their casts
col_name | col_type -------------+-------------------------- actor_id | smallint film_id | smallint
Sample results
first_name | last_name ------------+----------- GARY | PHOENIX DUSTIN | TAUTOU
Solution
postgresSELECT A.first_name, A.last_name
FROM film F
INNER JOIN film_actor FA
ON FA.film_id = F.film_id
INNER JOIN actor A
ON A.actor_id = FA.actor_id
WHERE F.title = 'AFRICAN EGG';Explanation
This query is selecting the first and last names of actors who have acted in the film 'AFRICAN EGG'. To do this, it's joining three tables - 'film', 'film_actor', and 'actor' - using the 'film_id' and 'actor_id' columns. The 'WHERE' clause is limiting the results to only show actors who have acted in the film 'AFRICAN EGG'.
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.