End of Summer - hours only!Up to 80% off on all courses and bundles.-Close
Function COUNT
Function AVG
Functions SUM, MAX, MIN


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


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.