📝 문제 https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true 📝 풀이
https://www.hackerrank.com/challenges/revising-the-select-query-2/problem?isFullScreen=true
https://www.hackerrank.com/challenges/select-all-sql/problem?isFullScreen=true
https://www.hackerrank.com/challenges/select-by-id/problem?isFullScreen=true
https://www.hackerrank.com/challenges/japanese-cities-attributes/problem?isFullScreen=true
https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-1/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-2/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-3/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-4/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-6/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-7/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-8/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-9/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-10/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-11/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true
https://www.hackerrank.com/challenges/more-than-75-marks/problem?isFullScreen=true
https://www.hackerrank.com/challenges/name-of-employees/problem?isFullScreen=true
https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true
https://www.hackerrank.com/challenges/what-type-of-triangle/problem?isFullScreen=true
📝 문제 https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true 📝 풀이
https://www.hackerrank.com/challenges/revising-aggregations-the-count-function/problem?isFullScreen=true
https://www.hackerrank.com/challenges/revising-aggregations-sum/problem?isFullScreen=true
https://www.hackerrank.com/challenges/revising-aggregations-the-average-function/problem?isFullScreen=true
https://www.hackerrank.com/challenges/average-population/problem?isFullScreen=true
https://www.hackerrank.com/challenges/japan-population/problem?isFullScreen=true
https://www.hackerrank.com/challenges/population-density-difference/problem?isFullScreen=true
https://www.hackerrank.com/challenges/the-blunder/problem?isFullScreen=true
📝 문제 https://www.hackerrank.com/challenges/earnings-of-employees/problem?isFullScreen=true 📝 풀이
https://www.hackerrank.com/challenges/weather-observation-station-13/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-14/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-15/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-16/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-17/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-18/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-19/problem?isFullScreen=true
https://www.hackerrank.com/challenges/asian-population/problem?isFullScreen=true
https://www.hackerrank.com/challenges/african-cities/problem?isFullScreen=true
https://www.hackerrank.com/challenges/average-population-of-each-continent/problem?isFullScreen=true
https://www.hackerrank.com/challenges/binary-search-tree-1/problem?isFullScreen=true
https://www.hackerrank.com/challenges/the-company/problem?isFullScreen=true
https://www.hackerrank.com/challenges/weather-observation-station-20/problem?isFullScreen=true
https://www.hackerrank.com/challenges/the-report/problem?isFullScreen=true
https://www.hackerrank.com/challenges/full-score/problem?isFullScreen=true업로드중..
https://www.hackerrank.com/challenges/harry-potter-and-wands/problem?isFullScreen=true
https://www.hackerrank.com/challenges/challenges/problem?isFullScreen=trueCTE 사용하여 hackers, challenge 두 테이블 조인하고 hacker_id, name 그룹 별로 challenge
https://www.hackerrank.com/challenges/contest-leaderboard/problem?isFullScreen=true서브쿼리에서 챌린지 당 최고점을 구해두고, 해당 점수를 메인 쿼리에서 해커 별로 sum 해주는 방식으로 풀었다.
https://www.hackerrank.com/challenges/sql-projects/problem?isFullScreen=truedays컬럼을 생성하여 인라인뷰 a로 사용, days는 시작일에서 row넘버를 뺀 날짜, 연속된 프로젝트의 경우 days가
https://www.hackerrank.com/challenges/placements/problem?isFullScreen=true
https://www.hackerrank.com/challenges/symmetric-pairs/problem?isFullScreen=true
https://www.hackerrank.com/challenges/interviews/problem?isFullScreen=true
https://www.hackerrank.com/challenges/15-days-of-learning-sql/problem?isFullScreen=true
https://www.hackerrank.com/challenges/draw-the-triangle-1/problem?isFullScreen=true
https://www.hackerrank.com/challenges/draw-the-triangle-2/problem?isFullScreen=true
📝 문제 https://www.hackerrank.com/challenges/print-prime-numbers/problem?isFullScreen=true 📝 풀이