title: summarize counts from multiple columns in a single table
body: <p>I want to display count of data of two category on single display</p>
  
  <p>my table like below :</p>
  
  <pre><code>table : funding
  area        client      Donatur
  -----------------------------------------
  A        Ox      Mr.X
  A        Pr      Mr.Y
  A        Qs      Mr.Z
  A        Ts      Mr.Z   
  B        Rt      Mr.X
  C        Ss      Mr.X   
  C        Sa      Mr.Z   
  </code></pre>
  
  <p>I want to display data to count based on area and donatur in on table like bellow </p>
  
  <pre><code>Donatur     Count of Area   Count of Client
  --------------------------------------------------------
  Mr.X          3             3
  Mr.Y          1             1
  Mr.Z          2             3
  </code></pre>
  
  <p>I have try to create query like below :</p>
  
  <p>select count(client),count(area) from funding group by area,donatur</p>
  
  <p>But i don't get any right number on one side, the result like below , same on both of them. It' should be like above</p>
  
  <pre><code>Donatur     Count of Area       Count of Client
  --------------------------------------------------------
  Mr.X          3             3
  Mr.Y          1             1
  Mr.Z          2             2
  </code></pre>