Introduction
Numbers
Boolean
Date and time
Summary

Instruction

As you can see, all the calculations seem correct now. That's good news for us.

Exercise

Okay! Let's go back to our table body and our Thumbelina problem. We changed the columns types to decimal. Again, select height, weight and calculate the third column expected_zero in the following way: height - weight - height + weight. The user_id for Thumbelina is 6. Will this calculation equal zero now? Let's find out!

Stuck? Here's a hint!

Type

SELECT height, weight, 
height - weight - height + weight AS expected_zero 
FROM body 
WHERE user_id = 6;

Console

Code editor

Result

TableConsole