Untitled

unknown
plain_text
a year ago
511 B
Indexable
Never
with users_2 as (SELECT DISTINCT user_id
                        FROM reports_stg.watch_content
                    WHERE video_id == 2  
               ),
     users_3 as (SELECT DISTINCT user_id
                        FROM reports_stg.watch_content
                    WHERE video_id == 3
               )
SELECT DISTINCT user_id 
    FROM reports_stg.watch_content
    WHERE video_id  = 1
            and user_id NOT IN (SELECT user_id FROM users_2)
            and user_id IN (SELECT user_id FROM users_3);