Using the customer_nodes and regions tables, calculate the total number of rows in customer_nodes for each region.
Show the columns region_name and total_nodes.
Sort by total_nodes DESC, region_name ASC.
Hints
-
Hint 1
customer_nodes contains the region id, not the name.
Join it with regions to get region_name.
-
Hint 2
Group by region_name.
Then count how many rows from customer_nodes fall into each group.