Introduction
Function AVG
18. AVG and GROUP BY
Functions SUM, MAX, MIN
Revision

Instruction

Correct! Of course, we can use AVG with GROUP BY, just as we used COUNT:

SELECT client_id, AVG(price)
FROM project
GROUP BY client_id;

The above query will find the average price each customer paid for their projects.

Exercise

Show each translator's id together with the average number of words they had to translate in all their projects. Exclude project with id 6 – it was cancelled.

Stuck? Here's a hint!

Use the inequality sign != to exclude project withid 6.

Console

Code editor

Result

TableConsole