목록2024/03/26 (1)
짜리몽땅 매거진
![](http://i1.daumcdn.net/thumb/C150x150/?fname=https://blog.kakaocdn.net/dn/Vhkz4/btsF6Ix4Oly/j1D3qERXmZyo5jyckyQlqk/img.png)
문제1. 멘토링 짝꿍 리스트 출처 : solvesql 연습문제 문제 정보 : 난이도 3 / 정답률 40.68% https://solvesql.com/problems/mentor-mentee-list/ 정답 쿼리 SELECT a.employee_id AS mentee_id, a.name AS mentee_name, b.employee_id AS mentor_id, b.name AS mentor_name FROM employees a cross join employees b WHERE a.join_date BETWEEN '2021-10-01' and '2021-12-31' AND b.join_date = o.order_delivered_customer_date THEN o.order_id END) AS su..
Data/SQL
2024. 3. 26. 20:29