Deals Of The Week - 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 last table.


The last table is a bit more complicated. It has many rows and many columns.

Select all the information from the last table: project. Note that you won't see all the rows present in the table – our platform displays only a limited number of rows for readability.

You can find the project_id, client_id and translator_id, of course. These columns should be clear. Then, you can also see:

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

Afterward, we can see the price the client paid, the number of words for translation 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.