Prepare > SQL > Basic Select > Weather Observation Station 4

Weather Observation Station 4 | HackerRank

 

문제

---

Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.

 

 

 

 

코드

---

SELECT COUNT(CITY) - COUNT(DISTINCT(CITY)) FROM STATION;