Untitled

 avatar
unknown
plain_text
2 years ago
515 B
6
Indexable
WITH users as (SELECT user_id, 
count(user_id) OVER ()
FROM tools_shop.users
WHERE CAST(DATE_TRUNC('month', created_at) as date) = '2020-01-01'),

events AS (SELECT *
               FROM tools_shop.events as android
               WHERE platform = 'android' AND CAST(DATE_TRUNC('month', event_time) as date) >='2020-01-01' AND 
               CAST(DATE_TRUNC('month', event_time) as date) <= '2020-03-01'
                   )

SELECT *
FROM users
INNER JOIN events
ON users.user_id = events.user_id;
Editor is loading...