Query the average population for all cities in CITY, rounded down to the nearest integer.
The CITY table is described as follows:
Average Population – Hacker Rank Solution
SELECT COUNT(CITY) - COUNT(DISTINCT CITY) FROM STATION;
Disclaimer: The above Problem (Average Population) generated by Hackerrank but the Solution is Provided by codeworld19. This tutorial is only for Educational and Learning purposes. Authority if any of the queries regarding this post or website fill the following contact form thank you.