Function COUNT
Function AVG
Functions SUM, MAX, MIN
Instruction
Great. Okay, one final piece of information: you can also use DISTINCT with MIN or MAX to find the minimum or maximum value, respectively.
SELECT MAX(DISTINCT price) FROM project;
What is the difference between MAX(price) and MAX(DISTINCT price)? Well, we hate to disappoint you, but there is none. :)
It's just an interesting fact about SQL that you can use DISTINCT with MIN or MAX but it won't change anything.
Exercise
Check it out for yourself. Show four columns:
- the maximum number of words in a project (as
max), - the maximum distinct number of words (as
max_distinct), - the minimum number of words (as
min), - and the minimum distinct number of words (as
min_distinct).
