Above the Title
A medium Python mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- 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 that fit that genre and rating bar.
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 and run your Python against test cases
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision