SQL

1. programmers SQL : GROUP BY

post-thumbnail

2.programmers SQL : JOIN

post-thumbnail

3.SQL REGEXP

post-thumbnail

4.programmers SQL : String, Date

post-thumbnail

6.LeetCode[MySQL] : Rank Scores

post-thumbnail

8.LeetCode[MySQL] : Employees Earning More Than Their Managers

post-thumbnail

14.programmers SQL : 우유와 요거트가 담긴 장바구니

post-thumbnail

15.MySQL ROLLUP GROUPING

post-thumbnail

16.MySQL CONCAT

post-thumbnail

17.REGEXP_SUBSTR / REGEXP_INSTR / REGEXP_REPLACE / REGEXP_LIKE

post-thumbnail

18.MySQL IFNULL COALESCE (NVL)

post-thumbnail

19.CASE WHEN 구문

post-thumbnail

20.RANK, DENSE_RANK, ROW_NUMBER

post-thumbnail

21.INSERT INTO / DELETE / UPDATE / PROCEDURE

post-thumbnail

22.VIEW, MECE

post-thumbnail

23.매출액 조회

post-thumbnail

24.HackerRank[MySQL] : Contest Leaderboard

post-thumbnail

25.HackerRank[MySQL] : Top Competitors

post-thumbnail

26.HackerRank[MySQL] : The PADS

post-thumbnail

27.HackerRank[MySQL] : Aggregation

post-thumbnail

29.HackerRank[MySQL] : Weather Observation Station

post-thumbnail

30.HackerRank[MySQL] : New Companies

post-thumbnail

46.상품 별 오프라인 매출 구하기

post-thumbnail

47.programmers SQL : GROUP BY

post-thumbnail

48.IF CASE WHEN

post-thumbnail

49.CURDATE, DATEDIFF, WEEKDAY

post-thumbnail

50.SUBQUERY

post-thumbnail

51.REGEXP

post-thumbnail

52.CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP

post-thumbnail

53.CAST DATETIME EXTRACT SUBSTRING

post-thumbnail

54.COALESCE

post-thumbnail