#162 Finding Students by Marks

Companies:

Rostelecom

Themes:

SQLJoinsAggregationSubqueriesPractice

The following tables are given:

groups
id
...

students
id | group_id
...

marks
id | student_id | value
...

Find all students who have no marks
Find students who have at least one mark above the overall average
Find students who have at least one mark above their group average

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.