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

Instruction

Ok, time to move on. Another function we're going to take a closer look at is AVG, which computes the average value. Let's start with AVG(column):

SELECT AVG(price)
FROM project;

The above query will find the average price for all projects.

Exercise

Find the average number of words from all projects with Spanish (ES) as the target language. Name the column average.

Stuck? Here's a hint!

Use a WHERE clause to select the lang_to.