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 vote180 views1 answer
Sql server bool select
SQL
0 vote196 views1 answer
Add sqlite3 in lumen
SQL
5 votes220 views1 answer
Oracle get ddl
SQL
5 votes203 views1 answer
Oracle asynchronous update
SQL
14 votes190 views2 answers
Oracle add column with default value
SQL
0 vote194 views1 answer
Oracle select partition
SQL
0 vote186 views1 answer
Exec procedure oracle
SQL
0 vote197 views1 answer
Mysql select smaller of two values
SQL
0 vote206 views8 answers
Convert sql query to linq online
SQL
0 vote234 views1 answer
Mysql c commands
SQL