Solve SQL CTR and Python analytics tasks

Part A — SQL Click-Through Rate Using PostgreSQL, produce one query that returns click-through rate (CTR) grouped by pin_format, considering only users from the US who are new at the time of the event. The schema is: users(user_id INT, country_code VARCHAR(2), signup_date DATE) pin_classification(pin_id INT, pin_format VARCHAR(20)) events(event_date DATE, user_id INT, pin_id INT, event_type VARCHAR(20), event_count INT) Connect events to users through user_id, and connect…