Suppose you work for a retail company and have access to two tables:
Customers:
| customer_id | city |
|---|---|
| 0 | New York |
| 1 | New York |
| 2 | Los Angeles |
| 3 | Jacksonville |
Suppliers:
| supplier_id | city |
|---|---|
| 0 | Omaha |
| 1 | New York |
| 2 | San Francisco |
| 3 | Los Angeles |
You've been tasked to find which cities have a strong overlap with both customers and suppliers, as your company explores opening an additional office. Using SQL, write a query to stack rank the frequency of the cities shown across both databases.
Your query should return the following elements:
City