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 vote274 views1 answer
Sql server concat null
SQL
0 vote278 views1 answer
Ver usuarios mysql
SQL
12 votes263 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote272 views1 answer
Pass array parameter to stored procedure c#
SQL
3 votes288 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote274 views1 answer
Sql date d'aujourd'hui
SQL
0 vote257 views1 answer
Opensuse start MySQL
SQL
0 vote325 views1 answer
Mssql last day of month
SQL
1 vote262 views1 answer
Oracle list constraints
SQL
2 votes292 views1 answer
Mysql shell insert into
SQL