MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
SELECT a.EmployerName, a.EmployerID, b.ActiveEmployees, c.PaidOutEmployees FROM Employers a LEFT JOIN (SELECT Count(Employees.EmployeeStatus) AS ActiveEmployees, Employees.EmployerID FROM Employees WHERE Employees.EmployeeStatus='ACTIVE' GROUP BY Employees.EmployerID, Employees.EmployeeStatus) b ON a.EmployerID=b.EmployerID LEFT JOIN (SELECT Count(Employees.PlanStatus) AS PaidOutEmployees, Employees.EmployerID FROM Employees WHERE Employees.PlanStatus='PAID OUT' GROUP BY Employees.EmployerID, Employees.PlanStatus) c ON b.EmployerID = c.EmployerID;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|awk and Pythagoras?||5||27|
|SQL Recursion schedule||13||35|
|Powershell finalizing the end of an array.||4||24|
|SQl query with join with out having to list all fields in main table.||2||16|