Introduction
Function COUNT
Function AVG
Functions SUM, MAX, MIN
Revision

Instruction

Okay. One more 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,
  2. the number of translators that have completed at least one project in that language combination.

Stuck? Here's a hint!

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

Console

Code editor

Result

TableConsole