Review
So you think you can count?
Rounding functions and more
Instruction
Okay. There's one more useful operator related to division: the modulo operator (%). It returns the remainder of one number divided by another number, like this:
x % y
For instance, 9 % 7 will return 2, because 9 / 7 is 1 with 2 as the remainder. This operator works with integer and decimal numbers.
Exercise
In our game, you can increase your strength by 1 if you sacrifice 7 HP. For each character, show its name and calculate how many health points will be left if the player decides to sacrifice the maximum number of HP. Name the column hp_left.
Stuck? Here's a hint!
Use this expression: hp % 7.
