substring2 SQL easy regex extraction Input You'll have a table like the following: namegreeting 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. namegreetinguser_id Austin Gaylord Hola que tal #4702665 4702665 Kacie Zulauf Bienvenido 45.. 2022. 7. 3. Countries Capitals for Trivia Night (SQL for Beginners #6) Your friends told you that if you keep coding on your computer, you are going to hurt your eyes. They suggested that you go with them to trivia night at the local club. Once you arrive at the club, you realize the true motive behind your friends' invitation. They know that you are a computer nerd, and they want you to query the countries table and get the answers to the trivia questions. Schema .. 2022. 6. 28. 이전 1 다음