Untitled

From Capacious Octupus, 3 Months ago, written in Plain Text, viewed 52 times.
URL http://codebin.org/view/c3d7b53f Embed
Download Paste or View Raw
  1. WITH
  2. t_12 AS (SELECT EXTRACT(MONTH FROM CAST(invoice_date AS date)) AS month,
  3.              SUM(total) AS sum_total_2012
  4.              FROM invoice
  5.              WHERE EXTRACT(YEAR FROM CAST(invoice_date AS timestamp)) = 2012
  6.              GROUP BY month),
  7. t_13 AS (SELECT EXTRACT(MONTH FROM CAST(invoice_date AS date)) AS month,
  8.              SUM(total) AS sum_total_2013
  9.              FROM invoice
  10.              WHERE EXTRACT(YEAR FROM CAST(invoice_date AS timestamp)) = 2013
  11.              GROUP BY month)
  12. SELECT t_12.month,
  13.        sum_total_2012,
  14.        sum_total_2013,
  15.        ROUND((sum_total_2013 - sum_total_2012)/sum_total_2013*100) AS perc
  16. FROM t_12 LEFT JOIN t_13 ON t_12.month=t_13.month
  17. ORDER BY perc;

Reply to "Untitled"

Here you can reply to the paste above