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

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. The column names should be: name, projects_no, and translators_no.

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. Remember about DISTINCT when counting the number of translators.