A description of the problem can be found on Hackerrank.
In a subselect selects
count of all
cities and unique
cities and then substract these numbers.
I created solution in:
All solutions are also available on my GitHub.
select num - num_uniq
select count(city) as num, count(distinct city) as num_uniq