SQL · Snowflake · Easy
You are a Data Analyst on Snowflake's Marketing Analytics team. Your task is to calculate the percentage of marketing touches that were of type 'webinar' during April 2022. Round the result to the nearest integer. Table Schema The events table records every marketing touch event for a contact. Column Name Type event_id integer contact_id integer event_type string event_date date event_id is the primary key. Example Input Output Explanation: In April 2022 there are 8…
Checking your access…