Learn
Great work! Numeric functions can be used to transform numbers. Some common SQLite mathematical functions are included below that take numeric data types as inputs:
SELECT (number1 + number2);
: Returns the sum of two numbers. Similar, SQL can be used for subtraction, multiplication, and division.SELECT CAST(number1 AS REAL) / number3;
: Returns the result as a real number by casting one of the values as a real number, rather than an integer.SELECT ROUND(number, precision);
: Returns the numeric value rounded off to the next value specified.
In our baked_goods
table, we have information about cost designated by ingredients_cost
. For accounting purposes, we’d like to make sure that each ingredient cost is rounded to four decimal places rather than two, to account for currency fluctuations.
SELECT ROUND(ingredients_cost, 4) as rounded_cost FROM baked_goods;
Instructions
1.
Find the bakery’s distance from the market rounded to two decimal places.
Be sure to alias the column as distance_from_market
.
Sign up to start coding
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.