Re: Задание 10

From windweb, 4 Months ago, written in SQL, viewed 86 times. This paste is a reply to Задание 10 from Николай - view diff

URL http://codebin.org/view/a21dfc34 Embed

Download Paste or View Raw

WITH agg AS
  (SELECT CAST(DATE_TRUNC('year', paid_at) AS DATE) AS YEAR,
          SUM(total_amt) AS total
   FROM tools_shop.orders
   GROUP BY CAST(DATE_TRUNC('year', paid_at) AS DATE)
   ORDER BY CAST(DATE_TRUNC('year', paid_at) AS DATE))
SELECT *,
       (LEAD(total, 1, total) OVER ()) - total AS delta
FROM agg

Reply to "Re: Задание 10"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?