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

Instruction

Fine! Let's do one more exercise which will show the difference between COUNT(*) and COUNT(column).

Exercise

The agency manager gets a bonus of 5 for each project which got some feedback.

Show the theoretical sum the project manager could get if all the projects got some feedback (theoretical_bonus) and the actual bonus (actual_bonus).

Stuck? Here's a hint!

Use COUNT twice and multiply it by 5 each time.

Console

Code editor

Result

TableConsole