Advertisement
AAMzz

Untitled

Jun 16th, 2022
32
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.13 KB | None | 0 0
  1. SELECT y12.MONTH,
  2.        y12.year_2011,
  3.        y12.year_2012,
  4.        y3.year_2013
  5. FROM
  6.     (SELECT y1.MONTH,
  7.            y1.year_2011,
  8.            y2.year_2012
  9.     FROM
  10.         (SELECT EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP)) AS MONTH,
  11.                COUNT(total) AS year_2011
  12.  
  13.         FROM invoice
  14.         WHERE EXTRACT(YEAR FROM CAST(invoice_date AS TIMESTAMP)) IN (2011)
  15.         GROUP BY EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP))) AS y1
  16.     LEFT OUTER JOIN
  17.         (SELECT EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP)) AS MONTH,
  18.                COUNT(total) AS year_2012
  19.  
  20.         FROM invoice
  21.         WHERE EXTRACT(YEAR FROM CAST(invoice_date AS TIMESTAMP)) IN (2012)
  22.         GROUP BY EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP))) AS y2 ON y1.MONTH = y2.MONTH) AS y12
  23. LEFT OUTER JOIN
  24.     (SELECT EXTRACT(MONTH FROM CAST(invoice_date AS TIMESTAMP)) AS MONTH,
  25.                COUNT(total) AS year_2013
  26.  
  27.         FROM invoice
  28.         WHERE EXTRACT(YEAR FROM CAST(invoice_date AS TIMESTAMP)) IN (2013)
  29.         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