BaşlayınÜcretsiz Başlayın

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"
      }
}

Bu egzersiz

Data Types and Functions in Snowflake

kursunun bir parçasıdır
Kursu Görüntüle

Uygulamalı interaktif egzersiz

Bu örnek kodu tamamlayarak bu egzersizi bitirin.

SELECT
    user_id,

	-- Retrieve the member's first name using dot-notation
    ___,

FROM CORE_GYM.members;
Kodu Düzenle ve Çalıştır