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 vote216 views1 answer
Get only structure database mysql
SQL
0 vote198 views1 answer
Sql revert migration
SQL
0 vote181 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
1 vote195 views1 answer
Blob datatype in mysql
SQL
0 vote249 views1 answer
Fetching data from mysqldb
SQL
1 vote192 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote169 views1 answer
Opensuse stop MySQL
SQL
24 votes199 views6 answers
Sql change table name
SQL
0 vote199 views1 answer
Grant owner postgresql
SQL
0 vote178 views2 answers
Postgres default user
SQL