Untitled

From Sludgy Leopard, 2 Months ago, written in Plain Text, viewed 58 times.

URL http://codebin.org/view/40f3f2c2 Embed

Download Paste or View Raw

table_1 as (SELECT CAST(DATE_TRUNC('month', event_time) as date) as month,
       COUNT(event_id) as events
FROM tools_shop.events
WHERE event_name LIKE 'view_item'
GROUP BY month)
 
SELECT month, 
       events,
       SUM(events) OVER (ORDER BY month)
FROM table_1

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