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

Standard SQL Functions

Reviewing SQL and numbers
So you think you can count
5. Problems with subtraction
Round and other functions
Review and practice

Instruction

Great! As you might expect, these simple operations can also get very tricky. Let's discuss them now.

We'll start with subtraction.

Exercise

For a character Mnah (name = 'Mnah'), select name, weight, height and the result of the following calculation: weight - height - weight + height (name the last column result). It should equal 0, right?

Stuck? Here's a hint!

Introduce a WHERE clause and remember to put the character name in apostrophes.