CTR By Pin-Format and Date

We are given three tables: events Column Name Type user_id int pin_id int event_date date event_type varchar users_d Column Name Type user_id int signup_date date country varchar pins_classification Column Name Type pin_id int pin_format varchar users_d.user_id is the primary key of that table, and pins_classification.pin_id is the primary key of its table. Write a query that computes the click-through rate (CTR = clicks / impressions) for each pin_format and event_date,…