The tickets table contains support tickets with a status.
Return one row with open_tickets, the number of tickets whose status is open.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
tickets7 rows| ticket_id (int) | status (string) |
|---|---|
| 1 | open |
| 2 | closed |
| 3 | open |
| 4 | pending |
| 5 | open |
| 6 | closed |
| 7 | resolved |
Column names and order must match. Sort order is specified in the question.