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.

If any of these values turns out to be NULL, show 0 instead.

Console

Code editor

Result

TableConsole