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 vote275 views1 answer
Oracle drop default value
SQL
0 vote296 views1 answer
Top frequency in sql server
SQL
0 vote317 views1 answer
Create table split string function in sql server
SQL
9 votes282 views2 answers
Mysql change value
SQL
0 vote279 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
1 vote243 views1 answer
Ms sql how to see active job current run time
SQL
0 vote290 views1 answer
Case insensitive sql
SQL
1 vote281 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
0 vote288 views1 answer
Mssql view column data type
SQL
0 vote313 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL