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

0 vote221 views1 answer
Mysql get nth highest
SQL
4 votes205 views4 answers
Rollback in sql
SQL
1 vote208 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
3 votes204 views1 answer
Locate sql server
SQL
0 vote195 views1 answer
Sqlite closes value
SQL
0 vote198 views1 answer
Console output pl sql
SQL
0 vote225 views1 answer
Login failed for user sql server
SQL
6 votes203 views1 answer
Oracle desc table primary key
SQL
15 votes218 views4 answers
Pl sql
SQL
0 vote204 views2 answers
Oracle sql for each row
SQL