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: