SELECT emp_num, emp_fname, emp_lname, emp_email, total FROM lgemployee JOIN (SEL
ID: 3666614 • Letter: S
Question
SELECT emp_num, emp_fname, emp_lname, emp_email, total FROM lgemployee JOIN (SELECT employee_id, Sum(line_qty) AS total FROM lginvoice i join lgline l ON i.inv_num = l.inv_num JOIN lgproduct p ON l.prod_sku = p.prod_sku JOIN lgbrand b ON b.brand_id = p.brand_id WHERE brand_name = 'BINDER PRIME' AND INV_DATE BETWEEN '01-NOV-11' AND '06-DEC-11' GROUP BY employee_id) sub ON emp.emp_num = sub.employee_id WHERE total = (SELECT Max(total) FROM (SELECT employee_id, Sum(line_qty) AS total FROM lginvoice i JOIN lgline l ON i.inv_num = l.inv_num JOIN lgproduct p ON l.prod_sku = p.prod_sku JOIN lgbrand b ON b.brand_id = p.brand_id WHERE brand_name = 'BINDER PRIME' AND INV_DATE BETWEEN '01-NOV-11' AND '06-DEC-11' GROUP BY employee_id));
Explanation / Answer
SELECT emp_num, emp_fname, emp_lname, emp_email, total FROM lgemployee JOIN (SELECT employee_id, Sum(line_qty) AS total FROM lginvoice i join lgline l ON i.inv_num = l.inv_num JOIN lgproduct p ON l.prod_sku = p.prod_sku JOIN lgbrand b ON b.brand_id = p.brand_id WHERE brand_name = 'BINDER PRIME' AND INV_DATE BETWEEN '01-NOV-11' AND '06-DEC-11' GROUP BY employee_id) sub ON emp.emp_num = sub.employee_id WHERE total = (SELECT Max(total) FROM (SELECT employee_id, Sum(line_qty) AS total FROM lginvoice i JOIN lgline l ON i.inv_num = l.inv_num JOIN lgproduct p ON l.prod_sku = p.prod_sku JOIN lgbrand b ON b.brand_id = p.brand_id WHERE brand_name = 'BINDER PRIME' AND INV_DATE BETWEEN '01-NOV-11' AND '06-DEC-11' GROUP BY employee_id))
everything seems fine, the statement has no errors.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.