Introduction
1. Introduction
Function AVG
Functions SUM, MAX, MIN
Revision

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 have a chance to learn some new information now.

Let's not waste a single moment. Today, we 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.

Console

Code editor

Result

TableConsole