Learn More Complex Filtering

The school recently held a competition for students who participated in Mathematics. Some students were rewarded, but now the school wants to ensure no students cheated by taking more than one exam, including the math exam.

Your task is to find the last names of students who took more than one exam, with one of them being Mathematics.

Here is the query from our previous assignment that you can use as an example:


              1234
            
SELECT student_surname, AVG(grade) as average_grade
FROM student_grades
GROUP BY student_surname
HAVING COUNT(grade) > 1

Task

Swipe to start coding

Retrieve the last names of those students who received more than one grade for the Mathematics exam.

Note

Retrieve only the surname of these students. The answer should have only one column.

Brief Instructions

Retrieve the student_surname column.
Use the WHERE clause to set subject_name = 'Mathematics'.
Group the results by student_surname.
Use the HAVING clause with COUNT(grade) > 1.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 8

single

Ask AI

Ask anything or try one of the suggested questions to begin our chat

Your task is to find the last names of students who took more than one exam, with one of them being Mathematics.

Here is the query from our previous assignment that you can use as an example:


              1234
            
SELECT student_surname, AVG(grade) as average_grade
FROM student_grades
GROUP BY student_surname
HAVING COUNT(grade) > 1

Task

Swipe to start coding

Retrieve the last names of those students who received more than one grade for the Mathematics exam.

Note

Retrieve only the surname of these students. The answer should have only one column.

Brief Instructions

Retrieve the student_surname column.
Use the WHERE clause to set subject_name = 'Mathematics'.
Group the results by student_surname.
Use the HAVING clause with COUNT(grade) > 1.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Section 1. Chapter 8

single

Swipe to show menu

Your task is to find the last names of students who took more than one exam, with one of them being Mathematics.

Here is the query from our previous assignment that you can use as an example:


              1234
            
SELECT student_surname, AVG(grade) as average_grade
FROM student_grades
GROUP BY student_surname
HAVING COUNT(grade) > 1

Task

Swipe to start coding

Retrieve the last names of those students who received more than one grade for the Mathematics exam.

Note

Retrieve only the surname of these students. The answer should have only one column.

Brief Instructions

Retrieve the student_surname column.
Use the WHERE clause to set subject_name = 'Mathematics'.
Group the results by student_surname.
Use the HAVING clause with COUNT(grade) > 1.

Solution

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

More Complex Filtering

Brief Instructions

Solution

Awesome!

More Complex Filtering

Brief Instructions

Solution

Awesome!

More Complex Filtering

Brief Instructions

Solution