Exercise

Is this a premium song?

In the last exercise, you used the Snowflake UI to explore the database and tables that you'll be working with. Throughout the course, we'll switch back and forth between the Snowflake UI and the query editor you see here. Now, it's time to get hands-on with CASE statements. First, you'll use the track table to categorize the unit price of each song. Let's get to it!

Instructions

100 XP

Begin a CASE statement to classify the price of a song.
If the unit_price of a song is 0.99, label it as a 'Standard Song'.
If instead a song's unit_price is 1.99, this should be labeled as a 'Premium Song'.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise