Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
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.