Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn More Complex Filtering | Grouping
Intermediate SQL with output checkers

bookMore 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
copy
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

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 8
single

single

Ask AI

expand

Ask AI

ChatGPT

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

Suggested prompts:

Can you help me modify the query to find students who took Mathematics and at least one other exam?

What should the output look like for this new query?

Can you explain how to join the necessary tables if there are multiple exam subjects?

close

Awesome!

Completion rate improved to 4

bookMore Complex Filtering

Swipe to show menu

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
copy
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 desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 1. ChapterΒ 8
single

single

some-alt