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 vote132 views1 answer
MQL4 mql4 run ea on all symbols by adding to just one chart
SQL
0 vote155 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
4 votes169 views1 answer
How to check last gather stats on table in oracle
SQL
2 votes132 views1 answer
How to find constraints on a table in oracle
SQL
0 vote121 views1 answer
Sql beginning of previous month
SQL
11 votes128 views4 answers
Query DISTINCT
SQL
2 votes146 views1 answer
Sql count having
SQL
0 vote153 views1 answer
Get create sql of hibernqte entity
SQL
2 votes141 views1 answer
Oracle to_char number format percentage
SQL
0 vote126 views1 answer
Sql insert tuple
SQL