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
Cities With More Customers Than Average Write a

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!