| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 |
Tags
- tableau
- Stack
- 파이썬
- lv4
- 완전탐색
- hackerrank
- coding test
- mysql
- 조합
- level4
- LeetCode
- Growth hacking
- 코딩테스트
- programmers
- 코테
- AARRR
- sql
- import re
- cte
- join
- itertools
- counter
- python
- lambda
- 프로그래머스
- 코딩
- time complexity
- Queue
- coding
- Level2
Archives
- Today
- Total
목록pivot table (1)
ror_coding
[HackerRank] Occupations
MySQL에서 Pivot 추출하는 방법! CASE-WHEN 을 사용한다. Question Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output should consist of four columns (Doctor, Professor, Singer, and Actor) in that specific order, with their respective names listed alphabetically under each column.Note: Print NULL when there are no..
Coding Test/SQL
2025. 4. 5. 17:30