Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Function COUNT
Function AVG
Functions SUM, MAX, MIN


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


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.