title: after joining three query not getting proper result in sql server
body: <p>I have three queries like this:</p>
  
  <pre><code>select count(*) as receved from transaction_tbl where locid=6 and status=0 
  Result 
  receved 
  3
  
  select count(*) as parked  from transaction_tbl where locid=6 and status=2
  result 
  parked  
  48
  
  select count(*) as requested from transaction_tbl where locid=6 and status=3
  result
  requested 
  5
  </code></pre>
  
  <p>i want join these three queries,so i wrote query like this:</p>
  
  <pre><code>select count(*) as receved,count(*) as parked,count(*) as requested 
  from transaction_tbl where locid=6 and status in(0,2,3) group by status
  </code></pre>
  
  <p>but now i got the result something like this</p>
  
  <pre><code>receved     parked      requested
  ----------- ----------- -----------
  3           3           3
  5           5           5
  48          48          48
  </code></pre>
  
  <p>and i trye query like this:</p>
  
  <pre><code>select count(*) as receved, count(*) as parked, count(*) as requested 
  from transaction_tbl
  where locid = 6 and status in (0,2,3);
  </code></pre>
  
  <p>but this time also am getting wrong result:
  if any help is very appreciable:</p>
  
  <p>i want answer like this:</p>
  
  <pre><code> receved     parked      requested
   ----------- ----------- -----------
  3             48           5
  </code></pre>
  
  <p>so how i can re-write the query</p>