Exercise

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.

Instructions 1/3

undefined XP

1

2

3

Using the SPLIT function on user_id, return only the text after the _; you can assume there is only one underscore in each user_id.

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

Instructions 1/3

Exercise