Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Function COUNT
Function AVG
Functions SUM, MAX, MIN
31. SUM, MAX and MIN – exercise
Review

## Instruction

Okay. Let's do one more exercise and practice SUM, MAX and MIN together.

## Exercise

For each translator, show their first and last name, followed by:

• the sum of the prices for all the projects they have completed (as sum).
• the maximum price (as max).
• the minimum price (as min).

Make sure that all translators are shown, and if any of these values turns out to be NULL, show 0 instead.

### Stuck? Here's a hint!

Use a LEFT JOIN to show all translators.