Introduction
Function COUNT
Function AVG
Functions SUM, MAX, MIN
Revision

Instruction

Well done. If you didn't know, you can also use COUNT(DISTINCT …) with an expression. Let's try it out right now.

Exercise

Count how many distinct rates per word our translation agency uses. To obtain the rate for one word, divide the price by number of words.

Make sure not to use integer division.

Console

Code editor

Result

TableConsole