Building a gym member description
To help prepare gym trainers for appointments with gym members, they get an email with details about that member's last workouts. However, the development team would like to include a snippet about the member themselves. To do this, they're looking to you to parse data in personal_info
column in the members
table to read something like this: Chris Wilson is a 56 year-old gym member.
. Remember, the personal_info
column is of type VARIANT
, with records that look like the below.
{
"age": "56",
"gender": "Female",
"name": {
"first": "Chris",
"last": "Wilson"
}
}
Este ejercicio forma parte del curso
Data Types and Functions in Snowflake
Ejercicio interactivo práctico
Prueba este ejercicio y completa el código de muestra.
SELECT
user_id,
-- Retrieve the member's first name using dot-notation
___,
FROM CORE_GYM.members;