[HackerRank] Weather Observation Station 4
2021. 1. 20. 20:47ㆍ데이터베이스/SQL
728x90
반응형
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:
SELECT COUNT(CITY) - COUNT(DISTINCT CITY)
FROM STATION'데이터베이스 > SQL' 카테고리의 다른 글
| [HackerRank] Weather Observation Station 6 (0) | 2021.01.21 |
|---|---|
| [HackerRank] Weather Observation Station 5 (0) | 2021.01.20 |
| [HackerRank] Weather Observation Station 3 (0) | 2021.01.20 |
| [HackerRank] Weather Observation Station 1 (0) | 2021.01.20 |
| [HackerRank] Japanese Cities' Attributes (0) | 2021.01.20 |