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

Instruction

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

Exercise

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.

Code editor
tableconsole