Given 2 tables, i want to find the % of users who saw fresh pins on a given day. Fresh is defined as a pin that has at least 2 impressions with impression_type =1 within 7 days of the created_date.
Table 1: pins
Table 2: events
user_id pin_id date_impression impression_type count
JohnSmith ABC 01/01/2018 1 1
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)