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
25. Exercise 3

Instruction

Nice! What about this next exercise?

Exercise

Each warrior at Level 3 or higher can perform a special attack whose damage is calculated as follows:

Character's strength added to one-fourth of its HP, and then multiplied by the absolute value of StatModifier.

For characters who have this attack available, show the character's name and the amount of damage dealt by this attack (column Damage).