SQL6 [HackerRank SQL] Weather Observation Station 3 (Oracle) Weather Observation Station 3 Problem 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. The STATION table is described as follows: (ID 번호가 짝수인 도시에 대해 STATION에서 CITY 이름의 목록을 작성하시오. 결과를 아무 순서로나 출력하되, 답변에서 중복을 제외하시오.) Solution(Oracle) SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0; MOD 함수 -.. 2024. 3. 27. [HackerRank SQL] Weather Observation Station 1 (Oracle) Weather Observation Station 1 Problem Query a list of CITY and STATE from the STATION table. The STATION table is described as follows: (STATION 테이블에서 CITY와 STATE를 조회하는 목록을 작성하시오. STATION 테이블은 다음과 같다:) Solution(Oracle) SELECT CITY, STATE FROM STATION ORDER BY CITY, STATE; 세미콜론(;) 작성을 까먹지 말자! https://www.hackerrank.com/challenges/weather-observation-station-1/problem Weather Observation Station 1.. 2024. 3. 26. 이전 1 2 다음
