Untitled

From Bulky Tapir, 4 Months ago, written in Plain Text, viewed 54 times.
URL http://codebin.org/view/95409173 Embed
Download Paste or View Raw
  1. WITH profiles AS (
  2.        SELECT u.user_id as user_id,
  3.               DATE_TRUNC('month', MIN(e.event_time))::date AS start_date
  4.        FROM tools_shop.events as e
  5.        JOIN tools_shop.users as u ON e.user_id = u.user_id
  6.        JOIN tools_shop.orders as o ON o.user_id = u.user_id
  7.        GROUP BY u.user_id)
  8. SELECT DISTINCT
  9. p.start_date,
  10. p.user_id
  11. FROM profiles as p
  12. JOIN tools_shop.events as e ON e.user_id = p.user_id
  13.  

Reply to "Untitled"

Here you can reply to the paste above