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

1 vote170 views1 answer
Get current date in pyspark sql
SQL
5 votes159 views2 answers
Oracle rename table
SQL
1 vote172 views1 answer
Oracle select row max date
SQL
1 vote141 views1 answer
Find logged in users mysql
SQL
0 vote143 views1 answer
Difference between min and max date sql
SQL
1 vote154 views1 answer
Sql string function update replace
SQL
2 votes100 views1 answer
Sql view column data type
SQL
0 vote159 views1 answer
Install sql server windows 10
SQL
0 vote151 views2 answers
SQL Server Standard
SQL
11 votes168 views1 answer
Oracle view source
SQL