Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
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.