Exercise

Extracting top level JSON keys

The Idaho field team is back at it again, they got a new weather station that is outputting JSON strings that they'd like you to get data out of for them. The JSON is in the CTE named weather_station for you to work with. It has the JSON string in the data column.

Instructions

100 XP

Extract the 'date' value from the data as weather_date.
Extract the 'weather' value from the data as weather_state.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise