Introduction
Function AVG
Functions SUM, MAX, MIN
Revision
35. Exercise 3

Instruction

Wow, correct again! Exercise 3 on its way.

Exercise

For each language combination in table project (e.g. EN to ES, ES to EN, DE to PL etc.) show lang_from, lang_to and the average price in this combination. When calculating the average, treat NULL values as 0.

Console

Code editor

Result

TableConsole