title: Month wise aging report by SQL query
body: <p>6 month aging report of the customers from today date.</p>
  
  <p>Data in the table is like following:</p>
  
  <pre><code>    Customer    Date        Amount  
      AAA         3-Sep-13    1000  
      BBB         4-Jan-14    4000  
      BBB         5-Feb-14    1000  
      AAA         3-Dec-13    3000    
      CCC         7-Nov-13    800  
      DDD         15-Nov-13   1000  
      DDD         25-Jan-13   1000  
      CCC         8-Nov-13    1000
  </code></pre>
  
  <p>I need a SQL query to get the below results and heading should be in month and year</p>
  
  <pre><code>    Party name  Sep-13  Oct-13  Nov-13  Dec-13  Jan-14  Feb-14  Total Amount  
      AAA         1000      0     0       3000      0      0      4000  
      BBB         0         0     0      4000     1000     0      5000  
      CCC         0         0     1800    0       0        0      1800  
      DDD         0         0     1000    0       1000     0      2000  
  </code></pre>