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:
Nice, quick and useful. A good challenge
Quick & easy
Thanks for the challenge. This, with the `group by all`, can be quite handy.
Although… so fresh out of the oven that it broke my linter…
H! here is my take. Thanks
Easy one with the function.