SQL/해커랭크 [MySQL] Weather Observation Station 7 - [문제] Weather Observation Station 7 | HackerRank Weather Observation Station 7 | HackerRank Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. www.hackerrank.com [문제 풀이] 이번에는 Weather Observation Station 6 문제와는 정반대로 모음으로 끝나는 도시들을 조회해보자. 시작하는 문자를 찾는 것은 LIKE '문자%' 인걸 보면 유추할 수 있듯이 끝나는 단어는 LIKE '%문자' 로 확인이 가능하다. [코드] SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE '%a' or CITY LIKE '%e' or CITY LIKE '%i' or CITY LIKE '%o' or CITY LIKE '%u' 공유하기 게시글 관리 Yoon-1212 'SQL > 해커랭크' 카테고리의 다른 글 [MySQL] Weather Observation Station 9 (0) 2022.10.09 [MySQL] Weather Observation Station 8 (0) 2022.10.09 [MySQL] Weather Observation Station 6 (0) 2022.10.09 [MySQL] Weather Observation Station 5 (0) 2022.10.09 [MySQL] Weather Observation Station 4 (0) 2022.10.09 Contents 당신이 좋아할만한 콘텐츠 [MySQL] Weather Observation Station 9 2022.10.09 [MySQL] Weather Observation Station 8 2022.10.09 [MySQL] Weather Observation Station 6 2022.10.09 [MySQL] Weather Observation Station 5 2022.10.09 댓글 0 + 이전 댓글 더보기