Frosty Friday

Snowflake Weekly Challenges

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

by on 8 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

8 responses to “Week 57 – Basic”

  1. ChrisHastie avatar
    ChrisHastie

    Nice, quick and useful. A good challenge

    • Solution URL – https://github.com/ChrisHastieIW/Frosty-Friday
  2. canonicalized avatar
    canonicalized

    Quick & easy

    • Solution URL – https://github.com/canonicalized/FrostyFriday/blob/main/WEEK57.sql
  3. dsmdavid avatar
    dsmdavid

    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
  4. av avatar
    av

    H! here is my take. Thanks

    • Solution URL – https://github.com/anabelcarol/Frosty-Friday/
  5. zlzlzl2 avatar
    zlzlzl2

    Easy one with the function.

    • Solution URL – https://github.com/zlzlzl2-data/FrostyFriday/blob/main/FF57_LZ.sql
  6. Non-deterministicNorman avatar
    Non-deterministicNorman

    I like 🙂

    • Solution URL – https://github.com/NMangera/frosty_friday/blob/main/week%2057%20-%20basic%20/ILIKE
  7. Chris B avatar
    Chris B

    Another nice little feature to learn about

    • Solution URL – https://github.com/ChrisBo94/FrostyFriday/blob/main/Week_57.sql
  8. gergana98 avatar
    gergana98

    Another handy feature!

    • Solution URL – https://github.com/GerganaAK/FrostyFridays/blob/main/Week%2057%20%E2%80%93%20Basic

Leave a Reply

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

  6. I like 🙂

    • Solution URL - https://github.com/NMangera/frosty_friday/blob/main/week%2057%20-%20basic%20/ILIKE

  7. Another nice little feature to learn about

    • Solution URL - https://github.com/ChrisBo94/FrostyFriday/blob/main/Week_57.sql

  8. Another handy feature!

    • Solution URL - https://github.com/GerganaAK/FrostyFridays/blob/main/Week%2057%20%E2%80%93%20Basic

Leave a Reply