Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

Introduction
Function AVG
20. AVG and NULLs only
Functions SUM, MAX, MIN
Review

Instruction

As you can see, NULL was not counted at all. Okay then, if NULL values are ignored when calculating the average, what would happen when ALL of the values were NULLs? Let's find out.

Exercise

Let's calculate the average number of words in all the projects done by translator with id = 5 again.

This time, though, exclude project_id = 13 from the rows so that the only two projects left are the ones with a NULL value. Name column average.

Stuck? Here's a hint!

Use the inequality sign != to exclude project_id 13. Use AND to join two conditions.