Practice Snowflake SQL Question | Real Coding Interviews

Quick Summary

Calculate the proportion of marketing touches classified as 'webinar' during April 2022.
Use conditional aggregation to count specific event types relative to the total volume in the filtered period.
Address edge cases where the date filter yields no rows by ensuring the result returns NULL rather than a misleading zero.

What This Tests

Common Patterns

Aggregation

Test Cases

Input

Output

Expected