The customers table contains customer locations.
Return country, city_count with the number of distinct cities in each country. Sort by country ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
customers10 rows| customer_id (int) | country (string) | city (string) |
|---|---|---|
| 1 | India | Mumbai |
| 2 | India | Delhi |
| 3 | India | Mumbai |
| 4 | USA | Austin |
| 5 | USA | Austin |
| 6 | USA | Seattle |
| 7 | Germany | Berlin |
| 8 | Germany | Berlin |
| 9 | Germany | Munich |
| 10 | Canada | Toronto |
Column names and order must match. Sort order is specified in the question.