Untitled

From Abrupt Guinea Pig, 4 Months ago, written in SQL, viewed 69 times.

URL http://codebin.org/view/0d8a122a Embed

Download Paste or View Raw

SELECT DISTINCT DATE_TRUNC('month', event_time)::DATE AS mnth
    , COUNT(event_id) OVER(PARTITION BY DATE_TRUNC('month', event_time)::DATE 
                    ORDER BY DATE_TRUNC('month', event_time)::DATE) AS count_month
    , COUNT(event_id) OVER(ORDER BY DATE_TRUNC('month', event_time)::DATE) AS count_month_cum
FROM tools_shop.events e
    JOIN tools_shop.users u ON e.user_id = u.user_id
    JOIN tools_shop.orders o ON u.user_id = o.user_id
WHERE event_name = 'view_item'

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?