Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Common Functions in MS SQL Server

Review
So you think you can count?
Rounding functions and more
Review and practice
24. Exercise 2

Instruction

Good. Another one coming up!

Exercise

A healing potion costs 50 gold coins. Calculate how many healing potions each character with an account balance of at least 100 can buy (column name PotionAmount) and how much money that character will have left after that purchase (column Change).

Stuck? Here's a hint!

Round PotionAmount down to the nearest whole integer.