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.