Summer Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Function AVG
25. AVG – additional exercise
Functions SUM, MAX, MIN
Review

Instruction

Good job! Let's do one more AVG exercise.

Exercise

For each translator, show their first and last name together with the average price of all the projects they have completed (as rounded_average). 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 (all completed projects are present in the project table).

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.