Aan de slagGa gratis aan de slag

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!

Deze oefening maakt deel uit van de cursus

Data Types and Functions in Snowflake

Cursus bekijken

Oefeninstructies

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

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

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;
Code bewerken en uitvoeren