Average Population SQL Hacker Rank Solution

Hello coders, In this post, you will learn how to solve the Average Population SQL Hacker Rank Solution. This problem is a part of the SQL Hacker Rank series.

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