Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Function AVG
Functions SUM, MAX, MIN
31. SUM, MAX and MIN – exercise
Revision

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,
  • the maximal price,
  • and the minimal price.

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.