A Netflix-style content team reports the total runtime of each show.
Return show_id, show_name, runtime_hours, where runtime is the sum of episode minutes divided by 60, rounded to 2 decimal places. Sort by show_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
episodes8 rows| show_id (string) | show_name (string) | episode_id (int) | runtime_minutes (int) |
|---|---|---|---|
| S1 | Midnight Heist | 1 | 52 |
| S1 | Midnight Heist | 2 | 48 |
| S2 | City of Kites | 1 | 60 |
| S2 | City of Kites | 2 | 58 |
| S2 | City of Kites | 3 | 62 |
| S3 | Signal Lost | 1 | 45 |
| S4 | The Quiet Kitchen | 1 | 30 |
| S4 | The Quiet Kitchen | 2 | 35 |
Column names and order must match. Sort order is specified in the question.