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 pin_id created_date ABC 01/01/2017 Table 2: events user_id pin_id date_impression impression_type count JohnSmith ABC 01/01/2018 1 1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)