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:

 1449729804 f21d187d0f CITY



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 Chase2Learn. 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