일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- 데이터시각화
- not in
- matplotlib
- SQLite
- having
- pandas
- 머신러닝
- 데이터리안 웨비나
- airflow.cfg
- Limit
- SUM
- 전처리
- solvesql
- 다중 JOIN
- 결측값
- PostgreSQL
- airflow 설치
- GROUPBY
- TRUNCATE
- MySQL
- join
- Oracle
- hackerrank
- 파이썬
- 데이터분석
- SQL
- Round
- 그로스해킹
- 프로그래머스
- seaborn
- Today
- Total
목록SQL/SQL 코딩 테스트-HackerRank (52)
Milky's note

https://www.hackerrank.com/challenges/weather-observation-station-7/problem?isFullScreen=true 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 describe..

https://www.hackerrank.com/challenges/weather-observation-station-6/problem?isFullScreen=true Weather Observation Station 6 | HackerRank Query a list of CITY names beginning with vowels (a, e, i, o, u). www.hackerrank.com [문제] Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates. Input Format The STATION table is described..

https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=true Weather Observation Station 5 | HackerRank Write a query to print the shortest and longest length city name along with the length of the city names. www.hackerrank.com [문제] Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of char..

https://www.hackerrank.com/challenges/weather-observation-station-4/problem?isFullScreen=true Weather Observation Station 4 | HackerRank Find the number of duplicate CITY names in STATION. www.hackerrank.com [문제] Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. The STATION table is described as follows: where LAT_N is..