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

11 votes166 views1 answer
Oracle view ddl
SQL
3 votes169 views2 answers
Mysql create timestamp column
SQL
0 vote181 views1 answer
Copy data from one postgres container to another
SQL
0 vote126 views1 answer
Oracle list all stored procedures
SQL
7 votes188 views1 answer
Return insert results in POSTGRESQL
SQL
1 vote161 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
2 votes188 views1 answer
Drop sequence
SQL
0 vote167 views1 answer
Show database not empty tables postgres
SQL
4 votes202 views3 answers
Mysql get column names from table
SQL
1 vote197 views1 answer
Sql and
SQL