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

3 votes346 views1 answer
Two select sql
SQL
1 vote355 views2 answers
One to one and one to many relationship
SQL
2 votes332 views1 answer
Laravel sql String
SQL
57 votes556 views5 answers
How to create a new user in postgresql
SQL
23 votes321 views4 answers
How to uninstall postgresql in ubuntu
SQL
1 vote338 views1 answer
Pgsql sum switch case
SQL
16 votes360 views6 answers
Mysql find duplicates in same table
SQL
1 vote314 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote267 views1 answer
Microsoft sql server management studio clear cache
SQL
1 vote348 views2 answers
Oracle create synonym
SQL