융무의 기술블로그
article thumbnail

https://www.hackerrank.com/challenges/weather-observation-station-11/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen

 

Weather Observation Station 11 | HackerRank

Query a list of CITY names not starting or ending with vowels.

www.hackerrank.com

  • query CITY names ==> SELECT CITY
  • from STATION table ==> FROM STATION
  • do not start or end with vowels ==> WHERE CITY REGEXP ‘^[^aeiou]|[^aeiou]$’
  • do not contain duplicates ==> SELECT DISTINCT CITY
select distinct city
from station
where city regexp '^[^aeiou]|[^aeiou]$';

profile

융무의 기술블로그

@융무

포스팅이 좋았다면 "좋아요❤️" 또는 "구독👍🏻" 해주세요!