Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT y12.MONTH,
- y12.year_2011,
- y12.year_2012,
- y3.year_2013
- FROM
- (SELECT y1.MONTH,
- y1.year_2011,
- y2.year_2012
- FROM
- (SELECT EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP)) AS MONTH,
- COUNT(total) AS year_2011
- FROM invoice
- WHERE EXTRACT(YEAR FROM CAST(invoice_date AS TIMESTAMP)) IN (2011)
- GROUP BY EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP))) AS y1
- LEFT OUTER JOIN
- (SELECT EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP)) AS MONTH,
- COUNT(total) AS year_2012
- FROM invoice
- WHERE EXTRACT(YEAR FROM CAST(invoice_date AS TIMESTAMP)) IN (2012)
- GROUP BY EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP))) AS y2 ON y1.MONTH = y2.MONTH) AS y12
- LEFT OUTER JOIN
- (SELECT EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP)) AS MONTH,
- COUNT(total) AS year_2013
- FROM invoice
- WHERE EXTRACT(YEAR FROM CAST(invoice_date AS TIMESTAMP)) IN (2013)
- GROUP BY EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP))) AS y3 ON y12.MONTH = y3.MONTH
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement