Notice
Recent Posts
Recent Comments
Link
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
31 |
Tags
- merge
- programmers
- 선형 모형
- leetcode
- RLIKE
- 교차 엔트로피
- Git
- 편향-분산 교환
- PYTHON
- 코딩공부
- elastic net
- HTML
- github
- sql
- coding
- 깃헙협업
- early stopping
- mysql
- branch
- L2정규화
- window function
- 온라인협업
- L1정규화
- AWS
- full request
- 클라우드컴퓨팅
- 버전충돌
- hackerrank
- conflict
- CSS
Archives
- Today
- Total
Im between cherry
Hackerrank | MySQL | Weather Observation Station 7 본문
Weather Observation Station 7
Weather Observation Station 7 | HackerRank
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION.
www.hackerrank.com
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. 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.
Solution
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';
'데이터분석 > practice_query' 카테고리의 다른 글
Hackerrank | MySQL | Weather Observation Station 9 (0) | 2020.08.28 |
---|---|
Hackerrank | MySQL | Weather Observation Station 8 (0) | 2020.08.27 |
Hackerrank | MySQL | Weather Observation Station 6 (0) | 2020.08.27 |
Hackerrank | MySQL | Weather Observation Station 5 (0) | 2020.08.27 |
Hackerrank | MySQL | Weather Observation Station 4 (0) | 2020.08.27 |
Comments