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


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.


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.