Comece agoraComece grátis

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 exercicio faz parte do curso

Data Types and Functions in Snowflake

Ver curso

Instruções do exercicio

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

exercicio interativo prático

Tente este exercicio 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 Código