JOIN two SELECT statement results

by 
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);

More Related Contents:

  1. SQL update from one Table to another based on a ID match
  2. SQL join: selecting the last records in a one-to-many relationship
  3. SQL SELECT from multiple tables
  4. What is the result of following SQL Query?
  5. Join vs. sub-query
  6. Can I use CASE statement in a JOIN condition?
  7. What is the difference between Left, Right, Outer and Inner Joins? [duplicate]
  8. Subqueries vs joins
  9. Difference between left join and right join in SQL Server [duplicate]
  10. Ms Access Query: Concatenating Rows through a query
  11. Difference between natural join and inner join
  12. Are “from Table1 left join Table2” and “from Table2 right join Table1” interchangeable?
  13. What is the difference between using a cross join and putting a comma between the two tables?
  14. Natural join in SQL Server
  15. Including null values in an Apache Spark Join
  16. Select only rows by join tables max value
  17. Select TOP X (or bottom) percent for numeric values in MySQL
  18. How to kill a running SELECT statement
  19. DATEDIFF function in Oracle [duplicate]
  20. How to select multiple rows filled with constants?
  21. How to select only the first rows for each unique value of a column?
  22. What is semi-join in database?
  23. sql group by only rows which are in sequence
  24. MySQL GROUP BY behavior
  25. SQL server join tables and pivot
  26. SQL: How do you select only groups that do not contain a certain value?
  27. How to select records without duplicate on just one field in SQL?
  28. SQL: Select rows with a column value that occurs at least N times?
  29. Is NATURAL (JOIN) considered harmful in production environment?
  30. How to do a case sensitive GROUP BY?

Leave a Comment