CommencerCommencez gratuitement

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!

Cet exercice fait partie du cours

<cours>Data Types and Functions in Snowflake</cours>
Voir le cours

Instructions de l’exercice

  • Update the SELECT statement to include a new field that adds a 25% uplift on the existing price_per_month.
  • Create a new column called plus_five_dollars that adds $5.00 to the price_per_month in the sp table.
  • Create another new column which divides the price_per_month by 2 - call this column half_off.

Exercice interactif pratique

Essayez cet exercice en complétant ce code d’exemple.

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;
Modifier et exécuter le code