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
1. Introduction
Function AVG
Functions SUM, MAX, MIN
Review

Instruction

Hello and welcome to Part 6 of our course. In this part, we're going to deal with aggregate functions. COUNT, AVG, MIN, MAX ... You know these already, but you'll now have a chance to learn some new information.

Let's not waste any time. Today, we have managed to obtain some data from a translation agency. Let's find out what we're going to deal with.

Exercise

Select all the information from the first table: client.

Each client (company) has an id and a name. Not really complicated, right? Let's move on when you're done.