| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 |
- 빅데이터분석기사
- 볼린저밴드
- 실기
- sarima
- ADP
- SQL
- 코딩테스트
- GridSearchCV
- 프로그래머스
- lstm
- 데이터분석
- docker
- PolynomialFeatures
- backtest
- Quant
- randomforest
- Python
- 파이썬
- Programmers
- 백테스트
- 주식
- 비트코인
- Crawling
- 파이썬 주식
- 파트5
- hackerrank
- 데이터분석전문가
- 변동성돌파전략
- TimeSeries
- 토익스피킹
- Today
- Total
목록SUBQUERY (2)
데이터 공부를 기록하는 공간
[hackerrank][SQL][Advanced]
https://www.hackerrank.com/domains/sql?filters%5Bskills%5D%5B%5D=SQL%20%28Advanced%29 Solve SQL Code Challenges A special-purpose language designed for managing data held in a relational database. www.hackerrank.com ☆ Draw The Triangle 1 SET @num = 21; SELECT REPEAT("* ", @num:=@num-1) /* for without table */ FROM INFORMATION_SCHEMA.TABLES WHERE @num > 0 Draw The Triangle 2 SET @num = 0; SELECT ..
[hackerrank][SQL][Intermediate]#3
https://www.hackerrank.com/domains/sql?filters%5Bskills%5D%5B%5D=SQL%20%28Intermediate%29 Solve SQL Code Challenges A special-purpose language designed for managing data held in a relational database. www.hackerrank.com Contest Leaderboard SELECT hacker_id, name, sum(score) FROM (select S.challenge_id challenge_id, H.hacker_id hacker_id, H.name name, max(S.score) score from Hackers H LEFT JOIN S..