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 vote179 views1 answer
Sub blocks in sql
SQL
22 votes191 views3 answers
Remove all records from table mysql
SQL
0 vote187 views2 answers
Athena drop partition
SQL
9 votes189 views4 answers
SQL Date Format
SQL
0 vote175 views1 answer
Update one column from another column in same table
SQL
11 votes186 views1 answer
Ddl materialized view
SQL
3 votes189 views1 answer
Define REGEXP?
SQL
0 vote184 views1 answer
Get the previous column of a table in mysql
SQL
0 vote184 views1 answer
Mysql default uuid
SQL
0 vote175 views1 answer
Save single sql query result boolean spring boot
SQL