Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

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.