From event_data, count events per utm_source using JSON_EXTRACT_SCALAR(properties, '$.utm_source')

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Problem

From event_data, count events per utm_source using JSON_EXTRACT_SCALAR(properties, '$.utm_source'). Name the count events. Exclude rows where utm_source IS NULL. Order by events descending, then utm_source.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.