Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

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.