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 vote184 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote181 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote182 views1 answer
Sql server sleep
SQL
0 vote177 views1 answer
Oracle sql developer closed connection
SQL
0 vote167 views1 answer
VSCode SQL Server Connection error
SQL
0 vote167 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
8 votes171 views3 answers
Oracle auto_increment
SQL
0 vote185 views1 answer
Insert value in identity
SQL
1 vote175 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
1 vote171 views2 answers
Sql drop multiple columns if exists
SQL