320x100
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(*)-COUNT(DISTINCT(CITY))
FROM STATION
320x100
320x100
'빅데이터 관련 자료 > [SQL] Basic' 카테고리의 다른 글
| Weather Observation Station 6 (0) | 2021.08.04 |
|---|---|
| Weather Observation Station 5 (0) | 2021.08.03 |
| Weather Observation Station 3 (0) | 2021.08.01 |
| Weather Observation Station 1 (0) | 2021.07.31 |
| Japanese Cities' Names (0) | 2021.07.30 |