Only this week, get the SQL Complete Track of 9 courses in a special prize of $330$89!
Introduction
Function COUNT
Function AVG
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.