Introduction
Function AVG
25. AVG – additional exercise
Functions SUM, MAX, MIN
Revision

Instruction

Good job! Let's do one more exercise.

Exercise

For each translator, show their first and last name together with the average price of all the projects they have completed. Round the price to two decimal places. Count only the projects with the number of words greater than 500. Exclude translators who have completed fewer than 2 projects.

Stuck? Here's a hint!

Use a WHERE clause to exclude projects shorter than 500 words.

In order to exclude translators with fewer than 2 projects, you'll need a HAVING clause with COUNT.

Console

Code editor

Result

TableConsole