Untitled

From Gentle Prairie Dog, 4 Months ago, written in Plain Text, viewed 66 times.

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

Download Paste or View Raw

SELECT
  DATE_TRUNC('year', CAST(o.created_at AS date)) AS order_year,
  ROUND(SUM(o.total_amt) / COUNT(DISTINCT u.user_id), 2) AS arppu
FROM tools_shop.users u
JOIN tools_shop.orders o ON o.user_id = u.user_id
GROUP BY order_year
ORDER BY order_year;

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?