Some payload JSON documents contain a nested 'details' object

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

Domain

SQL

Difficulty

medium

Problem

Some payload JSON documents contain a nested 'details' object. Extract the value at the path $.details.source from the payload column, aliased as traffic_source. Also return event_id. Only include rows where event_type is 'page_view'.

Practice This Problem

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