Rainbow Deals - hours only!Up to 80% off on all courses and bundles.-Close
3. Table project
Function AVG
Functions SUM, MAX, MIN


Good, let's take a look at the very last table.


Select all the information from the last table: project.

The last table is a bit more complicated.

You can find the project_id, client_id and translator_id, of course. These columns should be clear.

Then, you can see:

  • the start - that is, when the client commissioned the project,
  • the deadline - when the project is due.

Afterwards, we can see the price the client paid, the number of words to translate and two languages:

  • the source language (lang_from),
  • the target language (lang_to).

The final column (feedback) provides the client's feedback. Positive numbers mean that the client was very satisfied, negative ones mean that the client complained to some extent about the quality.