Course Content

Intermediate SQL

## Intermediate SQL

# Several Aggregate Functions in the Query

The school now knows the **last names** of those students who received more than one grade for exams, and the administration has decided to **calculate the average grade from multiple grades** of these students, and that will be their final grade.

You have to do this.

Here is the preview of a `student_grades`

table we are working with:

Task

You should **retrieve the last names** of students with more than one exam grade and also **calculate the average grade from all their grades**. In the response, you should have **2** columns: the first one is the `student_surname`

, and the second one is the `average_grade`

. Use `AVG()`

and `COUNT()`

aggregate functions in this task.

Also, sort the result by the `student_surname`

column in the ascending order.

Task

You should **retrieve the last names** of students with more than one exam grade and also **calculate the average grade from all their grades**. In the response, you should have **2** columns: the first one is the `student_surname`

, and the second one is the `average_grade`

. Use `AVG()`

and `COUNT()`

aggregate functions in this task.

Also, sort the result by the `student_surname`

column in the ascending order.

Everything was clear?

# Several Aggregate Functions in the Query

The school now knows the **last names** of those students who received more than one grade for exams, and the administration has decided to **calculate the average grade from multiple grades** of these students, and that will be their final grade.

You have to do this.

Here is the preview of a `student_grades`

table we are working with:

Task

You should **retrieve the last names** of students with more than one exam grade and also **calculate the average grade from all their grades**. In the response, you should have **2** columns: the first one is the `student_surname`

, and the second one is the `average_grade`

. Use `AVG()`

and `COUNT()`

aggregate functions in this task.

Also, sort the result by the `student_surname`

column in the ascending order.

Task

**retrieve the last names** of students with more than one exam grade and also **calculate the average grade from all their grades**. In the response, you should have **2** columns: the first one is the `student_surname`

, and the second one is the `average_grade`

. Use `AVG()`

and `COUNT()`

aggregate functions in this task.

Also, sort the result by the `student_surname`

column in the ascending order.

Everything was clear?

# Several Aggregate Functions in the Query

The school now knows the **last names** of those students who received more than one grade for exams, and the administration has decided to **calculate the average grade from multiple grades** of these students, and that will be their final grade.

You have to do this.

Here is the preview of a `student_grades`

table we are working with:

Task

**retrieve the last names** of students with more than one exam grade and also **calculate the average grade from all their grades**. In the response, you should have **2** columns: the first one is the `student_surname`

, and the second one is the `average_grade`

. Use `AVG()`

and `COUNT()`

aggregate functions in this task.

Also, sort the result by the `student_surname`

column in the ascending order.

Task

**retrieve the last names** of students with more than one exam grade and also **calculate the average grade from all their grades**. In the response, you should have **2** columns: the first one is the `student_surname`

, and the second one is the `average_grade`

. Use `AVG()`

and `COUNT()`

aggregate functions in this task.

Also, sort the result by the `student_surname`

column in the ascending order.

Everything was clear?

**last names** of those students who received more than one grade for exams, and the administration has decided to **calculate the average grade from multiple grades** of these students, and that will be their final grade.

You have to do this.

Here is the preview of a `student_grades`

table we are working with:

Task

**retrieve the last names** of students with more than one exam grade and also **calculate the average grade from all their grades**. In the response, you should have **2** columns: the first one is the `student_surname`

, and the second one is the `average_grade`

. Use `AVG()`

and `COUNT()`

aggregate functions in this task.

Also, sort the result by the `student_surname`

column in the ascending order.