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.

Console

Code editor

Result

TableConsole