일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |
- SQL
- 빅데이터분석기사
- Quant
- Programmers
- 볼린저밴드
- 프로그래머스
- randomforest
- backtest
- lstm
- PolynomialFeatures
- 코딩테스트
- 파이썬
- 파이썬 주식
- 데이터분석전문가
- 비트코인
- 데이터분석
- 주식
- GridSearchCV
- sarima
- 변동성돌파전략
- docker
- 백테스트
- Crawling
- Python
- 파트5
- hackerrank
- 토익스피킹
- TimeSeries
- ADP
- 실기
- Today
- Total
목록SQL (10)
데이터 공부를 기록하는 공간

https://www.hackerrank.com/challenges/interviews/problem Interviews | HackerRank find total number of view, total number of unique views, total number of submissions and total number of accepted submissions. www.hackerrank.com SELECT CON.contest_id, CON.hacker_id, CON.name, SUM(total_submissions) as A, SUM(total_accepted_submissions) as B, SUM(total_views) as C, SUM(total_unique_views) as D FROM..

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 ..

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..

↑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 ☆The Report select if(g.Grade >=8, s.Name, NULL), g.Grade, s.Marks from Students s left join Grades g on s.Marks between g.Min_Mark and g.Max_Mark order by g.Grade desc, s.Name ..