Untitled

From Chunky Bison, 10 Months ago, written in Plain Text, viewed 157 times.
URL http://codebin.org/view/dc9f2f0a Embed
Download Paste or View Raw
  1. SELECT *
  2. FROM (SELECT EXTRACT(MONTH FROM CAST(invoice_date AS date)) AS invoice_month,
  3.              COUNT(total) AS year_2011
  4.       FROM invoice
  5.       WHERE EXTRACT(YEAR FROM CAST(invoice_date AS date)) = 2011
  6.       GROUP BY invoice_month) AS y2011
  7. LEFT OUTER JOIN (SELECT COUNT(total) AS year_2012,
  8.                  EXTRACT(MONTH FROM CAST(invoice_date AS date)) AS invoice_month
  9.                  FROM invoice
  10.                  WHERE EXTRACT(YEAR FROM CAST(invoice_date AS date)) = 2012
  11.                  GROUP BY invoice_month) AS y2012 ON y2011.invoice_month = y2012.invoice_month
  12. LEFT OUTER JOIN (SELECT COUNT(total) AS year_2013,
  13.                  EXTRACT(MONTH FROM CAST(invoice_date AS date)) AS invoice_month
  14.                  FROM invoice
  15.                  WHERE EXTRACT(YEAR FROM CAST(invoice_date AS date)) = 2013
  16.                  GROUP BY invoice_month) AS y2013 ON y2012.invoice_month = y2013.invoice_month;

Reply to "Untitled"

Here you can reply to the paste above