Re: Re: Untitled

From Wet Hummingbird, 2 Months ago, written in SQL, viewed 53 times. This paste is a reply to Re: Untitled from Tacky Iguana - view diff

URL http://codebin.org/view/97fa1aa1 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 MONTH)     
FROM events_per_month
 

Reply to "Re: 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?