AVG Averaging
Beginner
The reporting screen shows the average age of your users. Calculate it in SQL. One user has no recorded age; that user should not drag the average down.
Write a query that returns a single value: the average of the age column of users.
Constraints
- Return a single row with a single column
- Users whose age is NULL are ignored (AVG does this for you)
Hints
Hint 1
AVG(column) averages a numeric column.
Hint 2
You do not need WHERE age IS NOT NULL; aggregates skip NULLs already.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.