Untitled

From Obese Ostrich, 4 Months ago, written in Plain Text, viewed 60 times.

URL http://codebin.org/view/82942871 Embed

Download Paste or View Raw

SELECT DISTINCT
        user_id,
        CAST(DATE_TRUNC('month', paid_at ) as date) AS month_nbr,
        MIN(CAST(DATE_TRUNC('month', paid_at ) as date)) OVER(PARTITION BY user_id) as cohort
FROM tools_shop.orders
ORDER BY user_id, month_nbr

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?