Question: Cities With More Customers Than Average Write a query which will return all cities with more customers than the average number of customers of all
Cities With More Customers Than Average
Write a query which will return all cities with more customers than the
average number of customers of all cities. For each such city, return the
country name, the city name and the number of customers. Order the
result by country name ascending.
Table definitions and a data sample are given below.
Schema
Table: country
Table: city
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
