Untitled

From Ilya, 2 Months ago, written in Plain Text, viewed 51 times.
URL http://codebin.org/view/bd105d6f Embed
Download Paste or View Raw
  1. SELECT year_2011.invoice_month,
  2.        year_2011,
  3.        year_2012,
  4.        year_2013
  5. FROM (
  6.     SELECT EXTRACT(MONTH FROM CAST(invoice_date AS date)) AS invoice_month,
  7.        COUNT(invoice_id) AS year_2011
  8. FROM invoice AS i
  9. WHERE EXTRACT(YEAR FROM CAST(invoice_date AS date)) = 2011
  10. GROUP BY 1
  11. ORDER BY 2 DESC
  12.     ) AS year_2011
  13. LEFT JOIN
  14.     (
  15.     SELECT EXTRACT(MONTH FROM CAST(invoice_date AS date)) AS invoice_month,
  16.        COUNT(invoice_id) AS year_2012
  17. FROM invoice AS i
  18. WHERE EXTRACT(YEAR FROM CAST(invoice_date AS date)) = 2012
  19. GROUP BY 1
  20. ORDER BY 2 DESC
  21.     ) AS year_2012 ON year_2011.invoice_month=year_2012.invoice_month
  22. LEFT JOIN
  23.     (
  24.     SELECT EXTRACT(MONTH FROM CAST(invoice_date AS date)) AS invoice_month,
  25.        COUNT(invoice_id) AS year_2013
  26. FROM invoice AS i
  27. WHERE EXTRACT(YEAR FROM CAST(invoice_date AS date)) = 2013
  28. GROUP BY 1
  29. ORDER BY 2 DESC
  30.     ) AS year_2013 ON year_2011.invoice_month=year_2013.invoice_month

Reply to "Untitled"

Here you can reply to the paste above