Planning for a new office, using SQL
Suppose you work for a retail company and have access to two tables:
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:
of times city appeared across both tables
Subscribe to premium account to see the solution.Get premium now