title: how to write aggregate conditional SQL query to get individual column counts and total counts by passing date arguments
body: <p>I did some thing like this:</p>
  
  <pre><code>with q1 as 
  ( 
    select x, count(*) as A from T1 where .. condition group by x
   ),
  q2 as ( select x, count(*) AS B  from T2 where .. condition group by x),
  q3 as ( select x, count(*) AS C from T3 where .. condition group by x),
  Q4 AS ( select x, count(*) AS D from T4 where .. condition group by x)
  
  SELECT Q1.X, Q1.A, Q2.B, Q3.C, Q4.D FROM Q1,Q2,Q3,Q4 
  </code></pre>
  
  <p>I only get blank results.. also i'm passing date as input arguments for each select. 
  column x exists in 4 different tables. All i have to do is show the count of x from each table for a particular date range. </p>