Re: struggling with a subquery

[Peter Brawley]

> SELECT risk, SUM(w2_wages) as total_wages FROM employees
> WHERE (SELECT risk FROM titles WHERE employee_title=title GROUP BY risk

Is this what you mean?

SELECT t.risk, SUM(e.w2_wages) as total_wages
FROM employees e
JOIN titles t ON e.employee_title=t.title
GROUP BY risk;



Edited 1 time(s). Last edit at 08/30/2020 12:58PM by Peter Brawley.