SQL · Pinterest · Medium
Below are the two analytics tasks. Work from the same three tables in both. Tables impression — one row per impression event. column type notes impression_id BIGINT primary key user_id BIGINT references user.user_id pin_id BIGINT references pin_info.pin_id surface VARCHAR placement of the event, e.g. 'home', 'search', 'profile' impression_ts TIMESTAMP UTC instant of the event country_code VARCHAR ISO country code, always filled in user column type notes user_id BIGINT…
Checking your access…