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

Instruction

Perfect. Now that you know more about COUNT, let's do some practice.

Exercise

For each client, show their name, the number of projects they have commissioned and the number of translators that have worked for that client. Do not count projects with a deadline within the last 3 months.

Stuck? Here's a hint!

Use CURRENT_TIMESTAMP to get the current date and time and INTERVAL '3' MONTH to go back in time. Use a LEFT JOIN and pay attention to proper counting.

Console

Code editor

Result

TableConsole