Right함수1 [MySQL] HackerRank SQL - Weather Observation Station 10 Problem Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. STATION의 테이블에서 모음으로 끝나지 않는 CITY명만 출력하라. 단, 중복은 제외하라. Answer1 SELECT CITY FROM STATION WHERE RIGHT(CITY,1) NOT IN ('a','e','i','o','u') GROUP BY CITY H.. 2022. 10. 20. 이전 1 다음
