Week 57 - SQL & Query Techniques

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:

1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘
2. Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
3. Post the URL in the comments of the challenge