일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- TRUNCATE
- solvesql
- 전처리
- MySQL
- SQLite
- not in
- hackerrank
- seaborn
- 결측값
- 데이터시각화
- Oracle
- SUM
- Round
- join
- 머신러닝
- 파이썬
- 데이터분석
- SQL
- PostgreSQL
- having
- 데이터리안 웨비나
- pandas
- Limit
- mysql :=
- 다중 JOIN
- GROUPBY
- 프로그래머스
- 그로스해킹
- matplotlib
- airflow 설치
- Today
- Total
목록SQL (51)
Milky's note
https://www.hackerrank.com/challenges/more-than-75-marks/problem?isFullScreen=true Higher Than 75 Marks | HackerRank Query the names of students scoring higher than 75 Marks. Sort the output by the LAST three characters of each name. www.hackerrank.com [문제] Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name. If two ..
https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true Weather Observation Station 12 | HackerRank Query an alphabetically ordered list of CITY names not starting and ending with vowels. www.hackerrank.com [문제] Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates. Input Fo..
https://www.hackerrank.com/challenges/weather-observation-station-11/problem?isFullScreen=true Weather Observation Station 11 | HackerRank Query a list of CITY names not starting or ending with vowels. www.hackerrank.com [문제] Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates. Input Format The STATION ta..
https://www.hackerrank.com/challenges/weather-observation-station-10/problem?isFullScreen=true Weather Observation Station 10 | HackerRank Query a list of CITY names not ending in vowels. www.hackerrank.com [문제] Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the n..