Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Function COUNT
Function AVG
Functions SUM, MAX, MIN
27. SUM with NULLs only
Review

Instruction

Good! Just like with AVG, SUM will return a NULL when all the values are NULL. Let's check it out.

Exercise

Remember the translator with translator_id = 5 Adriana Fuentes? Let's go back there again. Sum all the words from all her projects except for project_id = 13 so that you only sum NULLs. Name the column sum.

Stuck? Here's a hint!

Use a WHERE clause with two conditions joined by AND.