Week 69 – Intermediate

Deep within the haunted crypts of Snowflake, a mysterious function lurks in the shadows, waiting to be summoned this All Hallows’ Eve.

This arcane spell allows brave souls to compare the whispers of strings and magically score their eerie similarities. As the witching hour approaches, can you conjure this spectral function to decipher which incantations align the closest in their haunting harmonies? Beware, for only those truly versed in the dark arts will master this challenge! 🎃👻

CREATE OR REPLACE TABLE sentence_comparison(sentence_1 VARCHAR, sentence_2 VARCHAR);
INSERT INTO sentence_comparison (sentence_1, sentence_2) VALUES
('The cat sat on the', 'The cat sat on thee'),
('Rainbows appear after rain', 'Rainbows appears after rain'),
('She loves chocolate chip cookies', 'She love chocolate chip cookies'),
('Birds fly high in the', 'Birds flies high in the'),
('The sun sets in the', 'The sun set in the'),
('I really like that song', 'I really liked that song'),
('Dogs are truly best friends', 'Dogs are truly best friend'),
('Books are a source of', 'Book are a source of'),
('The moon shines at night', 'The moons shine at night'),
('Walking is good for health', 'Walking is good for the health'),
('Children love to play', 'Children love to play'),
('Music is a universal language', 'Music is a universal language'),
('Winter is coming soon', 'Winter is coming soon'),
('Happiness is a choice', 'Happiness is a choice'),
('Travel broadens the mind', 'Travel broadens the mind'),
('Dogs are our closest companions', 'Cats are solitary creatures'),
('Books are portals to new worlds', 'Movies depict various realities'),
('The moon shines brightly at night', 'The sun blazes hotly at noon'),
('Walking is beneficial for health', 'Running can be hard on knees'),
('Children love to play outside', 'Children love to play'),
('Music transcends cultural boundaries', 'Music is a universal language'),
('Winter is cold and snowy', 'Winter is coming soon'),
('Happiness comes from within', 'Happiness is a choice'),
('Traveling opens up perspectives', 'Travel broadens the mind');

The phantoms of code demand that you unveil sentences with scores that eclipse a chilling 90!

Expected outcome

4 responses to “Week 69 – Intermediate”

  1. mferle avatar

    Good one! Didn’t know this function before.

    • Solution URL – https://github.com/mferle/FrostyFriday/tree/main/Week%2069%20%E2%80%93%20Intermediate
  2. ChrisHastie avatar

    The solution looks so small and simple once you know the right function, but it was fun finding out which function to use!

    • Solution URL – https://github.com/ChrisHastieIW/Frosty-Friday
  3. dsmdavid avatar

    Thanks for the challenge. Good opportunity to refresh on functions to test similarities!

    • Solution URL – https://github.com/dsmdavid/frostyfridays-sf/blob/main/models/challenge_69.sql
  4. Chris B avatar
    Chris B

    Neat little function that could be useful in the future!

    • Solution URL – https://github.com/ChrisBo94/FrostyFriday/blob/main/Week_69.sql

Leave a Reply