Above the Title
A medium Python mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- Python
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
You have three exports from a film catalog: `movies` (each with a `movie_id`, `genre`, `rating`, and `box_office`), `actors` (each with an `actor_id` and `name`), and `mapping`, the bridge rows that pair an `actor_id` with a `movie_id`. For a given `genre` and `min_rating`, return each actor's `name` mapped to the total `box_office` of the films they appeared in whose genre matches and whose rating is at least `min_rating`. Leave out any actor with no qualifying film.
Summary
Some names carry a genre. Total the box office behind them.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your python solution with real code execution
- Get instant feedback and a hire/no-hire decision