Answer for SQL Subqueries nested in SELECT and FROM - solution 2

https://365datascience.com/dwqa-answer/answer-for-sql-subqueries-nested-in-select-and-from-solution-2/ -

Hi Paul!

Thanks for reaching out!

In similar situations, please try using another browser to download the necessary course resources – this sometimes helps.

Otherwise, please find the code pasted below. Thank you.

Hope this helps.
Best,
Martin

INSERT INTO emp_manager
SELECT 
u.*
FROM
(SELECT 
a.*
FROM
(SELECT 
e.emp_no AS employee_ID,
MIN(de.dept_no) AS department_code,
(SELECT 
emp_no
FROM
dept_manager
WHERE
emp_no = 110022) AS manager_ID
FROM
employees e
JOIN dept_emp de ON e.emp_no = de.emp_no
WHERE
e.emp_no <= 10020
GROUP BY e.emp_no
ORDER BY e.emp_no) AS a UNION SELECT 
b.*
FROM
(SELECT 
e.emp_no AS employee_ID,
MIN(de.dept_no) AS department_code,
(SELECT 
emp_no
FROM
dept_manager
WHERE
emp_no = 110039) AS manager_ID
FROM
employees e
JOIN dept_emp de ON e.emp_no = de.emp_no
WHERE
e.emp_no > 10020
GROUP BY e.emp_no
ORDER BY e.emp_no
LIMIT 20) AS b UNION SELECT 
c.*
FROM
(SELECT 
e.emp_no AS employee_ID,
MIN(de.dept_no) AS department_code,
(SELECT 
emp_no
FROM
dept_manager
WHERE
emp_no = 110039) AS manager_ID
FROM
employees e
JOIN dept_emp de ON e.emp_no = de.emp_no
WHERE
e.emp_no = 110022
GROUP BY e.emp_no) AS c UNION SELECT 
d.*
FROM
(SELECT 
e.emp_no AS employee_ID,
MIN(de.dept_no) AS department_code,
(SELECT 
emp_no
FROM
dept_manager
WHERE
emp_no = 110022) AS manager_ID
FROM
employees e
JOIN dept_emp de ON e.emp_no = de.emp_no
WHERE
e.emp_no = 110039
GROUP BY e.emp_no) AS d) as u;

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy