Reviewing SQL and numbers
So you think you can count
Round and other functions
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.
