728x90
https://solvesql.com/problems/mentor-mentee-list/
solvesql
solvesql.com
SELECT
a.employee_id mentee_id, a.name mentee_name, b.employee_id mentor_id, b.name mentor_name
FROM
employees a
left outer join employees b on a.department <> b.department
WHERE
a.join_date > '2021-10-01'
and b.join_date < '2020-01-01'
ORDER by
mentee_id, mentor_id728x90
'𝙎𝙌𝙇' 카테고리의 다른 글
| UNION과 UNION ALL의 차이 (1) | 2023.03.21 |
|---|---|
| 데이터 타입 변환 : CAST (0) | 2023.03.21 |
| [MySQL] 문자열 소문자/대문자 변경 : lower, upper, concat (0) | 2023.02.02 |
| [MySQL] 집계함수 : count, sum, avg, max, min, std, stdev_pop, variance, var_pop (0) | 2023.02.01 |
| [Solvesql] 쇼핑몰의 일일 매출액과 ARPPU (0) | 2023.01.31 |