Untitled

From Putrid Peafowl, 4 Months ago, written in Plain Text, viewed 53 times.
URL http://codebin.org/view/df9ec9e7 Embed
Download Paste or View Raw
  1. SELECT DISTINCT
  2.     CAST(DATE_TRUNC('month', event_time) as date) AS mnth,
  3.     COUNT(*) OVER(ORDER BY DATE_TRUNC('month', event_time)) as commul
  4. FROM tools_shop.events

Reply to "Untitled"

Here you can reply to the paste above