1. Học hỏi
  2. /
  3. Khoa Học
  4. /
  5. Data Manipulation in Snowflake

Connected

Bài tập

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!

Hướng dẫn

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