Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
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.