1. Learn
  2. /
  3. Courses
  4. /
  5. Data Manipulation in Snowflake

Connected

Exercise

Is this a long song?

Ever feel like a song is just dragging on? In this exercise, you're going to categorize each song based on its length, which is either short, normal, or long. Good luck!

Instructions

100 XP
  • Complete the SQL query to categorize a song less than 180000 milliseconds as a 'Short Song'.
  • In the next conditional statement, add logic to label a song with a length between 180000 and 300000 milliseconds as 'Normal Length'.
  • If neither of these conditions are met, set the value to 'Long Song'.
Powered by Snowflake