Best April deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Multiple metrics for a single object
Metrics for two groups
Ratios and percentages
8. Calculating ratios – step 3
Global vs. specific metrics
Summary

## Instruction

Good job! Even though we already computed the final ratio in step 2, we typically also want to round the ratio to a given number of decimal places. To that end, we can use the ROUND(value, decimal_places) function. Take a look:

SELECT
COUNT(CASE
WHEN ShippedDate IS NOT NULL
THEN OrderID
END) AS CountShipped,
COUNT(OrderID) AS CountAll,
ROUND(COUNT(CASE
WHEN ShippedDate IS NOT NULL
THEN OrderID
END) / CAST(COUNT(OrderID) AS float), 2) AS ShippedRatio
FROM Orders;


We surrounded the last column with the ROUND(..., 2) function invocation. Because the second argument is 2, we'll get the ratio rounded to two decimal places.

## Exercise

Modify the template code. Round the ratio from the DiscountedRatio column to three decimal places.

### Stuck? Here's a hint!

Wrap your division with a call to ROUND(..., 3). 