HackerRank_14. Weather Observation Station 8
문제 : Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates. SELECT distinct CITY FROM STATION WHERE SUBSTR(CITY, 1, 1) IN ('a', 'e', 'i', 'o', 'u') AND SUBSTR(CITY, -1, 1) IN ('a', 'e', 'i', 'o', 'u'); Upperco Aguanga East China East Irvine Amo Eleele Oconee Amazonia Aliso Viejo Anderso..
2020. 6. 11.
HackerRank_13. Weather Observation Station 7
문제 : Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. SUBSTR을 사용할 때 start의 위치를 -1로 지정해주었다. ( python의 list[-1] 느낌 ! ) SELECT distinct CITY FROM STATION WHERE SUBSTR(CITY, -1, 1) IN ('a', 'e', 'i', 'o', 'u'); Glencoe Chelsea Pelahatchie Dorrance Cahone Upperco Waipahu Millville Aguanga Morenci South El Monte Gustine Delano Westpha..
2020. 6. 11.
HackerRank_12. Weather Observation Station 6
문제 : Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. city의 첫번째 문자만 가져오기 위해서 SUBSTR 함수를 사용하자. SUBSTR(str, pos, len) 로 사용할 수 있다. MySQL : SUBSTR(), SUBSTRING() Oracle : SUBSTR() SQL Server : SUBSTRING() SELECT distinct CITY FROM STATION WHERE SUBSTR(CITY, 1, 1) IN ('a', 'e', 'i', 'o', 'u'); Arlington Albany Upperco Agua..
2020. 6. 11.
