Given 2 tables I want to find the % of users who saw fresh pins

See more:

SQL

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

What I have tried:

SELECT round(count(case when "created_date" = xyz then 1 else NULL end) / count(*)*100,2)
from
(
SELECT count(*)
FROM events e
where "impression_type" = 1
AND count >=2)