Weather Observation Station 4

  • + 0 comments

    There are two way to solve that problem;

    1. SELECT COUNT(city)-COUNT(DISTINCT(city) FROM Station;

    2. SELECT COUNT(city)-COUNT(DISTINCT(city) AS Difference FROM Station;