Semi-structured & modern warehouse SQL
Exercise · SQL & Querying

Predict, then run it

Predict the output

A struct {'depth': 4} has no temp field, and JSON {"depth":4} has no temp key. Access the present struct field and the missing JSON key side by side:

SELECT {'depth': 4}.depth AS depth, json_extract('{"depth":4}', '$.temp') AS json_temp;

Predict the exact output.