Re: Untitled

From Tacky Iguana, 2 Months ago, written in SQL, viewed 69 times. This paste is a reply to Untitled from Unique Gorilla - view diff

URL http://codebin.org/view/9cf5737d Embed

Download Paste or View Raw

WITH events_per_month AS (
SELECT DATE_TRUNC('month', event_time) AS MONTH,
       COUNT(*) AS events_count
FROM tools_shop.events
WHERE event_name = 'view_item'
GROUP BY DATE_TRUNC('month', event_time))
SELECT *,
       COUNT(events_count) OVER (ORDER BY DATE_TRUNC('month', event_time))       
FROM events_per_month

Replies to Re: Untitled

Title	Name	Language	When
Re: Re: Untitled	Wet Hummingbird	sql	2 Months ago.

Reply to "Re: Untitled"

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?