#87. [LeetCode / MySQL] 570. Managers with at Least 5 Direct Reports

문제 입력 코드 1. SELF JOIN SELECT e1.name FROM Employee AS e1 JOIN Employee AS e2 ON e1.id = e2.managerId GROUP BY e1.id HAVING count(e2.managerId) >= 5; 2. SUBQUERY SELECT name FROM Employee WHERE id IN ( SELECT managerId FROM Employee GROUP BY managerId HAVING COUNT(managerId) >= 5 ) 코드 설명 #SELECT #JOIN #SELF JOIN #GROUP BY #HAVING #COUNT #SUBQUERY #IN 문제 출처 Managers with at Least 5 Direct Reports ..

• format_list_bulleted SQL
• · 2023. 9. 13.
• textsms

#43. STRING, DATE : 루시와 엘라 찾기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. IN SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE FROM ANIMAL_INS WHERE NAME IN ('Lucy', 'Ella', 'Pickle', 'Rogan', 'Sabrina', 'Mitty') ORDER BY ANIMAL_ID; 2. 정규식 SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKE FROM ANIMAL_INS WHERE NAME REGEXP '^(Lucy|Ella|Pickle|Rogan|Sabrina|Mitty)$' ORDER BY ANIMAL_ID ASC; 코드 설명 #SELECT #WHERE #IN #REGEXP #ORDER BY 문제 출처 https://school.programmers.co.kr/learn/c..

• format_list_bulleted SQL
• · 2023. 8. 10.
• textsms

#05. SELECT : 흉부외과 또는 일반외과 의사 목록 출력하기 | 프로그래머스 | SQL 고득점 Kit

문제 입력 코드 1. WHERE - OR SELECT DR_NAME, DR_ID, MCDP_CD, DATE_FORMAT(HIRE_YMD, "%Y-%m-%d") AS HIRE_YMD FROM DOCTOR WHERE (MCDP_CD = 'CS') OR (MCDP_CD = 'GS') ORDER BY HIRE_YMD DESC, DR_NAME ASC; 2. WHERE - IN SELECT DR_NAME, DR_ID, MCDP_CD, DATE_FORMAT(HIRE_YMD, "%Y-%m-%d") AS HIRE_YMD FROM DOCTOR WHERE MCDP_CD IN ('CS', 'GS') ORDER BY HIRE_YMD DESC, DR_NAME ASC; 코드 설명 #SELECT #DATE_FORMAT #WHERE ..

• format_list_bulleted SQL
• · 2023. 5. 20.
• textsms