Exercise

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!

Instructions

100 XP

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.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Exercise