All Problems
70

Subject-wise Top Scorer

MediumJOINMAXGROUP BY

Problem Description

Write a SQL query to find the highest marks in each subject.

Expected Columns

  • subject_name
  • max_marks

Example Output

| subject_name | max_marks | |--------------|-----------| | Mathematics | 95 | | Physics | 92 | | Chemistry | 94 | | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#70 Subject-wise Top Scorer
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results