On January 21th at 14:15 UTC , progression through exercises will be unavailable for 10 minutes due to a planned maintenance break.
Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
Function COUNT
Function AVG
Functions SUM, MAX, MIN
Review

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.