It's Autumn! Prices fall like leaves! - 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.