Introduction
Function COUNT
Function AVG
Functions SUM, MAX, MIN
Revision

Instruction

As you may already suspect, COUNT(DISTINCT expression) can be also used together with GROUP BY. Try it out in the below exercise.

Exercise

Show translator id together with number of distinct rates per word he used in his projects.

Stuck? Here's a hint!

To obtain the rate per word, use CAST(price AS numeric)/words.

Console

Code editor

Result

TableConsole