JOIN two SELECT statement results
Use UNION
:
SELECT ks, COUNT(*) AS '# Tasks' FROM Table GROUP BY ksUNIONSELECT ks, COUNT(*) AS '# Late' FROM Table WHERE Age > Palt GROUP BY ks
Or UNION ALL
if you want duplicates:
SELECT ks, COUNT(*) AS '# Tasks' FROM Table GROUP BY ksUNION ALLSELECT ks, COUNT(*) AS '# Late' FROM Table WHERE Age > Palt GROUP BY ks