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

Data Types in SQL

Numerical data types
Integer data types
Floating point data types
Decimal data types
15. decimal precision
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 to the decimal data type. Again, select the height and 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!