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 vote159 views1 answer
Database traccar
SQL
0 vote251 views1 answer
Database timezone
SQL
0 vote176 views1 answer
Plsql check how much space all databases are consuming
SQL
8 votes168 views4 answers
How to calculate the age from date of birth in python
SQL
1 vote123 views2 answers
Get date from datetime postgresql
SQL
0 vote165 views1 answer
Oracle table free space
SQL
5 votes175 views1 answer
Oracle list days between two dates
SQL
0 vote162 views1 answer
List all indexes postgres
SQL
0 vote155 views1 answer
Mysql count number of occurrences in a column
SQL
0 vote182 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL