ComeçarComece de graça

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!

Este exercício faz parte do curso

Data Types and Functions in Snowflake

Ver curso

Instruções do exercício

  • 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.

Exercício interativo prático

Experimente este exercício completando este código de exemplo.

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;
Editar e executar o código