Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

Introduction
Function COUNT
Function AVG
Functions SUM, MAX, MIN
Review

Instruction

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:

SELECT COUNT(*)
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.

Exercise

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.