title: Using two Count() functions without changing the results
body: <pre><code>SELECT CARRIER.CARRIERID, PLAN.PLANID, PLNDESCRIPTION,
    COUNT(MEMBER.PLANID) AS MBRCNT
  FROM CARRIER
  LEFT OUTER JOIN PLAN
     ON CARRIER.CARRIERID = PLAN.CARRIERID
  LEFT OUTER JOIN MEMBER
     ON PLAN.PLANID = MEMBER.PLANID
  GROUP BY CARRIER.CARRIERID, PLAN.PLANID, PLNDESCRIPTION
  ORDER BY CARRIER.CARRIERID;
  </code></pre>
  
  <p>results in</p>
  
  <pre><code>CARR     PLANID PLNDESCRIPTION                 MBRCNT
   ---- ---------- ----------------------------------- ----------
   ANTH          4 Single SuperMed                              6
   ANTH          5 2-Party SuperMed                             4
   ANTH          6 Family SuperMed                              7
   BCBS          1 Single Basic Medical                         9
   BCBS          2 2-Party Basic Medical                       15
   BCBS          3 Family Basic Medical                        11
   DLT           7 Single Dental Only                           6
   DLT           8 Family Dental Only                           0
   MM           10 Single SuperMed with Dental                  5
   MM           11 2-Party SuperMed with Dental                 0
   MM           12 Family SuperMed with Dental                  2
   NWD           9 Life Only                                    2
   PHC                                                          0
  </code></pre>
  
  <p>and </p>
  
  <pre><code>SELECT CARRIER.CARRIERID, COUNT(PLAN.CARRIERID)
  FROM CARRIER
  LEFT OUTER JOIN PLAN
    ON CARRIER.CARRIERID = PLAN.CARRIERID
  LEFT OUTER JOIN MEMBER
    ON PLAN.PLANID = MEMBER.PLANID
  GROUP BY CARRIER.CARRIERID
  ORDER BY CARRIER.CARRIERID;
  </code></pre>
  
  <p>result in</p>
  
  <pre><code>CARR                   COUNT(PLAN.CARRIERID)
   ---- ---------------------------------------
   ANTH                                      17
   BCBS                                      35
   DLT                                        7
   MM                                         8
   NWD                                        2
   PHC                                        0
  </code></pre>
  
  <p>How can I combine these to get all of the rows next to each other?</p>