Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
Given a table named ‘events‘ with a column ‘items‘ that contains an array of values, which SQL query would transform each item of the array into a separate row?
A
SELECT user_id, event_timestamp, event_name, ARRAY(items) AS item FROM events;
B
SELECT user_id, event_timestamp, event_name, items FROM events;
C
SELECT user_id, event_timestamp, event_name, UNNEST(items) AS item FROM events;
D
SELECT user_id, event_timestamp, event_name, explode(items) AS item FROM events;
