Update sql join multiple tables

JOIN Multiple Select Statements as tables

SELECT t1.ks, t1.[# Tasks], COALESCE(t2.[# Late], 0) AS [# Late]
FROM 
    (SELECT ks, COUNT(*) AS '# Tasks' FROM Table GROUP BY ks) t1
LEFT JOIN
    (SELECT ks, COUNT(*) AS '# Late' FROM Table WHERE Age > Palt GROUP BY ks) t2
ON (t1.ks = t2.ks);

Source: stackoverflow.com

Similar codes

31 votes219 views4 answers
Mysql grant execute
SQL
0 vote324 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote205 views1 answer
Get created time of database psql 8
SQL
-1 vote209 views1 answer
Mysql delete duplicate rows except one
SQL
2 votes210 views3 answers
3 days back in sql server
SQL
0 vote221 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote273 views1 answer
Postgres extract number from string
SQL
0 vote208 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote218 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote247 views1 answer
Mysql 3 months ago
SQL