Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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 a 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 contracting 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. Name the column projects_no.

Stuck? Here's a hint!

Use a WHERE clause to select the ID.