Function COUNT
Function AVG
Functions SUM, MAX, MIN
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.
