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.

Code editor

TableConsole