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 vote136 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote132 views1 answer
Firebird where
SQL
0 vote141 views2 answers
Transaction php
SQL
3 votes118 views1 answer
Oracle user quota unlimited
SQL
1 vote137 views1 answer
Snowflake rename column name
SQL
2 votes150 views1 answer
Insert from table tsql
SQL
5 votes115 views1 answer
Mysql get last day of month
SQL
0 vote127 views4 answers
Database stuck at restoring state
SQL
0 vote139 views1 answer
Oracle change password expiration policy
SQL
-2 votes132 views1 answer
Mysql see users and passwords
SQL