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 vote228 views1 answer
Join to find results not in another table
SQL
10 votes248 views2 answers
Tsql merge example
SQL
1 vote220 views1 answer
Real world example of nosql
SQL
0 vote213 views1 answer
Hibernate with springboot mysql
SQL
0 vote233 views1 answer
Mysql join only one column
SQL
0 vote222 views1 answer
Mod in sql
SQL
2 votes235 views1 answer
How to show the whole table in sql
SQL
0 vote226 views1 answer
How to put is null in where in clause
SQL
1 vote240 views3 answers
Execute sp in sql server
SQL
2 votes273 views3 answers
How to replace null values in sql
SQL