Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Function AVG
Functions SUM, MAX, MIN
29. SUM and DISTINCT
Revision

Instruction

Perfect. Again, you can also sum distinctive values only:

SELECT SUM(DISTINCT price)
FROM project;

Exercise

Remember client id = 10 with their repetitive projects? Let's find the sum of all the words in their projects, but only count the repetitive projects once.