Adjusting membership prices
The business development team is mulling a change to their membership prices. They've come to you with the ask to build out a handful of different options and provide the results. In this example, you'll be doing exactly that!
This exercise is part of the course
Data Types and Functions in Snowflake
Exercise instructions
- Update the
SELECTstatement to include a new field that adds a 25% uplift on the existingprice_per_month. - Create a new column called
plus_five_dollarsthat adds$5.00to theprice_per_monthin thesptable. - Create another new column which divides the
price_per_monthby2- call this columnhalf_off.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
m.user_id,
m.sign_up_date,
m.subscription_plan,
sp.price_per_month AS original_price,
-- Add a 25% uplift to the existing price per month
___ * 1.25 AS twenty_five_percent_uplist,
-- Increase the price_per_month by $5.00
___ ___ ___ AS ___,
-- Divide the price per month by 2
___
FROM CORE_GYM.subscription_plans AS sp
JOIN CORE_GYM.members AS m
ON sp.subscription_plan = m.subscription_plan;