Click here to navigate the course.

Drag the edges to resize the window.

In Projects, you can keep track of your progress as you go throught the tasks. Check each item as you complete it!

Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Learn
SELECT price, ROUND(AVG(downloads), 2) FROM fake_apps GROUP BY price;

By default, SQL tries to be as precise as possible without rounding. We can make the result set easier to read using the ROUND() function.

ROUND() is a function that takes a column name and an integer as an argument. It rounds the values in the column to the number of decimal places specified by the integer. Here, we pass the column AVG(downloads) and 2 as arguments. SQL first calculates the average for each price and then rounds the result to two decimal places in the result set.

Report a Bug
If you see a bug or any other issue with this page, please report it here.