It's Autumn! Prices fall like leaves! - 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
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.