LinkedIn has been awash with people noticing quiet progress on Snowflake’s SQL functionality. And this challenge wants to highlight one cool feature.
Finish the following query:
with step_one as ( select 1 as numone, 2 as numtwo, 3 as numthree, 'a' as letterone, 'b' as lettertwo, 'c' as letterthree, '+' as symbolone, '#' as symboltwo, ';' as symbolthree ) select * ilike '' from step_one
The result should be:
Remember, if you want to participate:
- Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘
- Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
- Post the URL in the comments of the challenge