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.
Aggregate Functions


SQL uses the AVG function to quickly calculate the average value of a particular column.

The statement below returns the average number of downloads for an app in our database:

SELECT AVG(downloads) FROM fake_apps;

The AVG function works by taking a column name as an argument and returns the average value for that column.

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