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


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


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.