On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Numbers
Boolean
Date and time
Summary

Instruction

Nice. Did you try to insert a value like 1.236? Did you see what happened? It was rounded to 1.24. This is because we specified two digits after the decimal point when creating the column. Once you provide the precision and scale, you can't exceed it.

Exercise

Let's check how much tax Peter is going to pay. Select 0.15 of every amount from the payment table. Name this column tax.

Stuck? Here's a hint!

Type:

SELECT 0.15 * amount AS tax
FROM payment;