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!
This exercise is part of the course
Data Manipulation in Snowflake
Exercise instructions
- Begin a
CASEstatement to classify the price of a song. - If the
unit_priceof a song is0.99, label it as a'Standard Song'. - If instead a song's
unit_priceis1.99, this should be labeled as a'Premium Song'.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
name,
composer,
-- Begin a CASE statement
___
-- A song priced at 0.99 should be a 'Standard Song'
WHEN ___ = ___ THEN '___'
-- Songs costing 1.99 should be denoted as 'Premium Song'
___ unit_price = 1.99 ___ '___'
END AS song_description
FROM store.track;