Frosty Friday

Snowflake Weekly Challenges

You are here: Home / Uncategorized / Week 57 – Basic

by on 5 Comments

Week 57 – Basic

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

Reader Interactions

Comments

  3. 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…

    • Solution URL - https://github.com/dsmdavid/frostyfridays-sf/blob/main/models/challenge_57.sql

Leave a Reply