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

Instruction

Okay. One more COUNT exercise, this time with some date functions.

Exercise

For each language combination (e.g. EN to ES, ES to EN, DE to PL etc.) show lang_from, lang_to and two more columns:

  1. the number of projects completed in this combination (as projects_no).
  2. the number of translators that have completed at least one project in that language combination (as translators_no).

All completed projects are present in the project table.

Stuck? Here's a hint!

Use COUNT twice. Remember that translators may have completed more than one project, so you'll need DISTINCT.