Transforming text data
If you take a look, all user_id's in the members table start with user_ followed by a string of numbers. You're interested in providing members with their unique user ID, minus the user_ prefix. This will allow them to quickly sign in to their app and the gym itself. In this exercise, you'll practice using two different tools to do this.
Bu egzersiz
Data Types and Functions in Snowflake
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT
user_id,
-- Return all the text after user_ in the user_id field
___(user_id, '___')[___] AS split_user_id
FROM CORE_GYM.members;