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 |
Tags
- update
- Statistics
- t분포
- torch
- Window Function
- NLP
- 논문리뷰
- 표준편차
- GRU
- LSTM
- MySQL
- sql
- 설명의무
- airflow
- sigmoid
- leetcode
- SQL코테
- 짝수
- 자연어 논문 리뷰
- 서브쿼리
- 코딩테스트
- 자연어처리
- inner join
- SQL 날짜 데이터
- 자연어 논문
- 그룹바이
- HackerRank
- 카이제곱분포
- CASE
- nlp논문
Archives
- Today
- Total
목록Weather Observation Station 5 (1)
HAZEL
[ SQL : LENGTH ] hackerrank : Weather Observation Station 5
Weather Observation Station 5 >> 문제 Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically. The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the..
DATA ANALYSIS/SQL
2021. 10. 25. 20:24