Introduction
3. Table project
Function AVG
Functions SUM, MAX, MIN
Revision

Instruction

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

Exercise

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.

Console

Code editor

Result

TableConsole