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!
Este exercicio faz parte do curso
Data Manipulation in Snowflake
Instruções do exercicio
- 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'.
exercicio interativo prático
Tente este exercicio completando este código de exemplo.
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;