Write Queries for Pinterest Engagement Tasks

The following exercises use product-analytics data similar to a social pinboard platform. Unless a task says otherwise, convert timestamps to dates using UTC. Interpret every time interval as closed on its left endpoint and open on its right endpoint. Task 1: SQL — Click-through rate by pin format for newly registered US users Tables: events event_id BIGINT: unique event id. user_id BIGINT: the user who performed the action. pin_id BIGINT: the pin involved in the action.…