Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
Function COUNT
Function AVG
Functions SUM, MAX, MIN


Nice. Now that you know the tables, let's get down to work.

We'll start off with the function you already know: COUNT(*), which is used to count all the rows in the result set. Just like this:

FROM translator
WHERE start_date > '2016-01-01';

The above query will provide the number of translators who started collaborating with the translation agency on January 1, 2016 or later.


Now's your turn. Count the number of all the projects for the client with id 1.

Stuck? Here's a hint!

Use a WHERE clause to pick the id.