Average Population – Hacker Rank Solution

Average Population - Hacker Rank Solution
Average Population – Hacker Rank Solution

Problem

Query the average population for all cities in CITY, rounded down to the nearest integer.

Input Format

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.

Leave a Comment

Your email address will not be published. Required fields are marked *