Hey team! I can't download the solution posted in the SQL Subqueries nested in SELECT and FROM - solution 2 part of the sql course. I tried using chrome, safari and mozilla but the download didn't work. Highly appreciate if you can help me on this.

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_managerSELECT u.*FROM(SELECT a.*FROM(SELECT e.emp_no AS employee_ID,MIN(de.dept_no) AS department_code,(SELECT emp_noFROMdept_managerWHEREemp_no = 110022) AS manager_IDFROMemployees eJOIN dept_emp de ON e.emp_no = de.emp_noWHEREe.emp_no <= 10020GROUP BY e.emp_noORDER 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_noFROMdept_managerWHEREemp_no = 110039) AS manager_IDFROMemployees eJOIN dept_emp de ON e.emp_no = de.emp_noWHEREe.emp_no > 10020GROUP BY e.emp_noORDER BY e.emp_noLIMIT 20) AS b UNION SELECT c.*FROM(SELECT e.emp_no AS employee_ID,MIN(de.dept_no) AS department_code,(SELECT emp_noFROMdept_managerWHEREemp_no = 110039) AS manager_IDFROMemployees eJOIN dept_emp de ON e.emp_no = de.emp_noWHEREe.emp_no = 110022GROUP 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_noFROMdept_managerWHEREemp_no = 110022) AS manager_IDFROMemployees eJOIN dept_emp de ON e.emp_no = de.emp_noWHEREe.emp_no = 110039GROUP BY e.emp_no) AS d) as u;

back

Follow this topic

Paul Dalagan

Last answered:

April 16, 2020

Posted on:

April 12, 2020

SQL Subqueries nested in SELECT and FROM - solution 2

1 answers ( 0 marked as helpful)

Martin Ganchev

Posted on:

April 16, 2020

Submit an answer

Content