Problem Statement : Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.
The STATION table is described as follows:
where LAT_N is the northern latitude and LONG_W is the western longitude.
For example, if there are three records in the table with CITY values 'New York', 'New York', 'Bengalaru', there are 2 different city names: 'New York' and 'Bengalaru'.
Answer will be (Total cities) - (Unique cities)=3-2=1
For this challenge, we must:
Use a Count() aggregate function to count the cities.
Use a Count() again to find Distinct cities then subtract.
SELECT Count(CITY) - Count(Distinct (CITY))
Hope you understand !!!
If you have any questions let me know in the comment section.