HACKERRANK 3일차

U_in_joy·2022년 5월 18일
1

SQL

목록 보기
3/16
post-thumbnail

Weather Observation Station 8

SELECT DISTINCT CITY 
FROM STATION 
WHERE CITY REGEXP '^[aeiou]' AND CITY REGEXP '[aeiou]$'



Weather Observation Station 9

SELECT DISTINCT CITY
FROM STATION
WHERE CITY NOT REGEXP '^[aeiou]';

NOT을 한 번 붙여봤는데 성공했다!



Weather Observation Station 10

SELECT DISTINCT CITY
FROM STATION
WHERE CITY NOT REGEXP '[aeiou]$'
profile
끝까지 가자!

0개의 댓글