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

Creating Tables in SQL

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;