Above the Title

A medium Python interview practice problem on DataDriven. Write and execute real python code with instant grading.

Domain

Python

Difficulty

medium

Seniority

L4

Problem

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.

Practice This Problem

Solve this Python problem with real code execution. DataDriven runs your Python code in a real environment and grades it automatically.