중급 문제풀이 https://inf.run/bzA1
수강의 목표는
기존에 배웠던 SQL 기초와 SQLD 시험 준비를 자연스럽게 연결하면서 내용을 갈무리하는 것.
이론적인 부분과 문제풀이를 겸하면서 차근차근 배우니까 원하던대로 정리가 잘 됐다. :D
'백문이불여일타'라는 이름처럼 한 번이라도 더 타이핑하면서 익히는 게 좋은 방법이라는 생각이 든다.
- 복습을 위한 문제 목록
Weather Observation Station 6: https://www.hackerrank.com/challenges/weather-observation-station-6/problem
Weather Observation Station 12: https://www.hackerrank.com/challenges/weather-observation-station-12/problem
Top Earners: https://www.hackerrank.com/challenges/earnings-of-employees/problem
Type of Triangle: https://www.hackerrank.com/challenges/what-type-of-triangle/problem
Symmetric Pairs: https://www.hackerrank.com/challenges/symmetric-pairs/problem
Leetcode 1179. Reformat Department Table: https://leetcode.com/problems/reformat-department-table/
Leetcode 595. Big Countries: https://leetcode.com/problems/big-countries/
Leetcode 620. Not Boring Movies: https://leetcode.com/problems/not-boring-movies/
Leetcode 182. Duplicate Emails: https://leetcode.com/problems/duplicate-emails/
Leetcode 175. Combine Two Tables: https://leetcode.com/problems/combine-two-tables/
Japan Population: https://www.hackerrank.com/challenges/japan-population/problem
Weather Observation Station 2: https://www.hackerrank.com/challenges/weather-observation-station-2/problem
Weather Observation Station 18: https://www.hackerrank.com/challenges/weather-observation-station-18/problem
New Companies: https://www.hackerrank.com/challenges/the-company/problem
▶ https://hjryu09.tistory.com/3
Population Density Difference: https://www.hackerrank.com/challenges/population-density-difference/problem
Weather Observation Station 11: https://www.hackerrank.com/challenges/weather-observation-station-11/problem
▶ https://hjryu09.tistory.com/4
Weather Observation Station 13: https://www.hackerrank.com/challenges/weather-observation-station-13/problem
Top Competitors: https://www.hackerrank.com/challenges/full-score/problem
▶ https://hjryu09.tistory.com/5
Weather Observation Station 3: https://www.hackerrank.com/challenges/weather-observation-station-3/problem
Weather Observation Station 19: https://www.hackerrank.com/challenges/weather-observation-station-19/problem
Placements: https://www.hackerrank.com/challenges/placements/problem
▶ https://hjryu09.tistory.com/10
Binary Tree Nodes: https://www.hackerrank.com/challenges/binary-search-tree-1/problem
▶ https://hjryu09.tistory.com/11
'노트1 > SQL' 카테고리의 다른 글
[MySQL] 프로그래머스 문제풀이 : GROUP BY, WITH RECURSIVE (재귀) (0) | 2022.02.10 |
---|---|
[MySQL] LeetCode 문제풀이 : CASE문 테이블피봇 (1179. Reformat Department Table) (0) | 2021.12.21 |
[MySQL] HackerRank 문제풀이 : JOIN (Placements) (0) | 2021.12.14 |
[MySQL] 프로그래머스 문제풀이 : LIKE와 IN, 와일드카드% (0) | 2021.12.13 |
[MySQL] HackerRank 문제풀이 : JOIN, HAVING (Top Competitors) (0) | 2021.12.10 |