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

Instruction

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

SELECT
  SUM(DISTINCT price)
FROM project;

Exercise

For client with id = 10, find the sum of the number of words in their projects, and the sum of the distinct number of words in their project. Name the columns sum and distinct_sum. Note that the results differ.