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

Instruction

Good! Of course, you can use COUNT(*), COUNT(column), or COUNT(expression) with GROUP BY.

Exercise

For each client, show their client_id and the number of projects commissioned by that specific client which have some feedback.

Stuck? Here's a hint!

Remember to use COUNT(feedback) instead of COUNT(*).

Console

Code editor

Result

TableConsole