HackerRank SQL 정리표 🗓

* 스터디원분께서 정리하신 표가지고 와서,, 살짝 내 맘대로 정리를 쫌 해봤다 *

 

Basic 📝

순서	제목	난이도	작성 블로그 주소	Y/N
1	Revising the Select Query I	Easy	SELECT,조건(WHERE)	Y
2	Revising the Select Query II	Easy		Y
3	Select All	Easy		Y
4	Select By ID	Easy		Y
5	Japanese Cities' Attributes	Easy	WHERE,DISTINCT,COUNT	Y
6	Japanese Cities' Names	Easy		Y
7	Weather Observation Station 1	Easy		Y
8	Weather Observation Station 3	Easy		Y
9	Weather Observation Station 4	Easy		Y
10	Weather Observation Station 6	Easy	LIMIT,REGEXP,LIKE,REGEXP_LIKE	Y
11	Weather Observation Station 7	Easy		Y
12	Weather Observation Station 8	Easy		Y
13	Weather Observation Station 9	Easy		Y
14	Weather Observation Station 10	Easy	REGEXP,RIGHT,SUBSTRING,SUBST	Y
15	Weather Observation Station 11	Easy		Y
16	Weather Observation Station 12	Easy		Y
17	Higher Than 75 Marks	Easy		Y
18	Employee Names	Easy		Y
19	Employee Salaries	Easy	CASE,CONCAT,||,SUBSTR,LOWER,COUNT,SUM	Y
20	Type of Triangle	Easy		Y
21	The PADS	Medium		Y
22	Revising Aggregations - The Count Function	Easy		Y
23	Revising Aggregations - The Sum Function	Easy		Y
24	Revising Aggregations - Averages	Easy	AVG,ROUND,SUM,MAX,MIN,CEILING(올림)	Y
25	Average Population	Easy		Y
26	Japan Population	Easy		Y
27	Population Density Difference	Easy		Y
28	The Blunder	Easy		Y
29	Top Earners ⭐️	Easy	HAVING,GROUPBY,COUNT,SUM ,ROUND,TRUNCATE,MAX,LIMIT	Y
30	Weather Observation Station 2	Easy		Y
31	Weather Observation Station 13	Easy		Y
32	Weather Observation Station 14	Easy		Y
33	Weather Observation Station 15	Easy		Y
34	Weather Observation Station 16	Easy	MIN,ROUND,SQRT(루트), POWER(제곱),JOIN	Y
35	Weather Observation Station 17	Easy		Y
36	Weather Observation Station 18	Medium		Y
37	Weather Observation Station 19	Medium		Y
38	Population Census	Easy		Y
39	African Cities	Easy	JOIN,FLOOR(버림),GROUPBY,LIMIT ,CASE~WHEND~END,INNERJOIN,DISTINCT	Y
40	Average Population of Each Continent	Easy		Y

 

Intermediate 📝

순서	제목	난이도	작성 블로그 주소	Y/N
1	Weather Observation Station 5	Easy	JOIN,FLOOR(버림),GROUPBY,LIMIT ,CASE~WHEND~END,INNERJOIN,DISTINCT	Y
2	Binary Tree Nodes	Medium		Y
3	New Companies	Medium		Y
4	Weather Observation Station 20	Medium
5	The Report	Medium
6	Top Competitors	Medium
7	Ollivander's Inventory	Medium
8	Challenges	Medium
9	Contest Leaderboard	Medium
10	SQL Project Planning	Medium
11	Placements	Medium
12	Symmetric Pairs	Medium
13	Interviews	Hard

 

Advanced 📝

순서	제목	난이도	작성 블로그 주소	Y/N
1	15 Days of Learning SQL	Hard
2	Draw The Triangle 1	Easy
3	Draw The Triangle 2	Easy
4	Print Prime Numbers	Medium