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 vote182 views1 answer
Oracle dynamic select into
SQL
0 vote172 views1 answer
Dump multiple tables mysql
SQL
-1 vote209 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote187 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
10 votes187 views1 answer
Oracle object dependencies
SQL
0 vote188 views1 answer
How to install mysql without admin rights
SQL
0 vote189 views2 answers
How to display enum value sql server
SQL
4 votes185 views1 answer
Oracle error compilation line
SQL
1 vote193 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
32 votes188 views6 answers
Insert into values select
SQL