Weather Observation Station 3

Weather Observation Station 3
Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.

id가 짝수인 도시를 중복 없이 출력하는 문제다.

-- 3개의 결과가 같다
SELECT DISTINCT city
FROM station
WHERE id % 2 = 0

SELECT DISTINCT city
FROM station
WHERE MOD(id, 2) = 0

SELECT DISTINCT city
FROM station
WHERE id MOD 2 = 0

💡

• 또 = 대신 == 썼었다! 주의주의!
• MOD() 함수는 나머지를 반환하는 함수다
• MOD(N, M), N MOD M : N을 M으로 나눈 나머지 반환
• N % m : N을 M으로 나눈 나머지 반환