The products table records each product's supplier.
Return supplier, product_count for each supplier. Sort by supplier ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
products8 rows| product_id (string) | supplier (string) |
|---|---|
| P1 | Acme |
| P2 | Acme |
| P3 | Beta |
| P4 | Gamma |
| P5 | Beta |
| P6 | Acme |
| P7 | Delta |
| P8 | Gamma |
Column names and order must match. Sort order is specified in the question.