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 Embed
Download Paste or View Raw
  1. WITH events_per_month AS (
  2. SELECT DATE_TRUNC('month', event_time) AS MONTH,
  3.        COUNT(*) AS events_count
  4. FROM
  5. WHERE event_name = 'view_item'
  6. GROUP BY DATE_TRUNC('month', event_time))
  7. SELECT *,
  8.        COUNT(events_count) OVER (ORDER BY DATE_TRUNC('month', event_time))      
  9. FROM events_per_month

Replies to Re: Untitled rss

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