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

2 votes250 views1 answer
Mysql trigger after update
SQL
-1 vote251 views4 answers
Postgres between dates
SQL
0 vote190 views1 answer
Sql view index
SQL
0 vote239 views1 answer
Drop domain postgresql
SQL
0 vote219 views1 answer
Mysql dump with table query
SQL
21 votes239 views3 answers
Sql server search column name in all tables
SQL
1 vote221 views1 answer
Convert to hexadecimal sql
SQL
4 votes242 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote207 views1 answer
R write csv without index
SQL
0 vote327 views1 answer
Provera dupliranih konatakata
SQL