코딩테스트연습(SQL)
Weather Observation Station 4 / HackerRank, SQL, MySQL
LearnerToRunner
2022. 11. 30. 10:02
문제
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:
제출답안(MySQL)
SELECT COUNT(city) - COUNT(DISTINCT(city)) FROM station
문제 바로가기(MySQL)
728x90