7 kyu
SQL easy regex extraction
2,821Javatlacati
Description:
Input
You'll have a table like the following:
| name | greeting |
|---|---|
| Austin Gaylord | Hola que tal #4702665 |
| Kacie Zulauf | Bienvenido 45454545 tal #470815 BD. WA470815 |
Output
In this practice you'll need to extract from the greeting column the number preceeded by the # symbol and place it in a new column named user_id.
| name | greeting | user_id |
|---|---|---|
| Austin Gaylord | Hola que tal #4702665 | 4702665 |
| Kacie Zulauf | Bienvenido 45454545 tal #470815 BD. WA470815 | 470815 |
NOTE: To keep it simple assume that the iser_id will be having varchar type
Regular Expressions
Fundamentals
Data Science
Similar Kata:
Stats:
| Created | Dec 7, 2018 |
| Published | Dec 7, 2018 |
| Warriors Trained | 6522 |
| Total Skips | 691 |
| Total Code Submissions | 19000 |
| Total Times Completed | 2821 |
| SQL Completions | 2821 |
| Total Stars | 93 |
| % of votes with a positive feedback rating | 84% of 377 |
| Total "Very Satisfied" Votes | 283 |
| Total "Somewhat Satisfied" Votes | 66 |
| Total "Not Satisfied" Votes | 28 |
| Total Rank Assessments | 17 |
| Average Assessed Rank | 7 kyu |
| Highest Assessed Rank | 6 kyu |
| Lowest Assessed Rank | 8 kyu |
