42

Class-wise Average Marks

MediumJOINAVGGROUP BY

Problem Description

Write a SQL query to find the average marks for each class.

Expected Columns

  • class
  • avg_marks

Example Output

| class | avg_marks | |-------|-----------| | 9 | 78.5 | | 10 | 80.33 | | 11 | 82.67 | | 12 | 84.0 |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#42 Class-wise Average Marks
Medium

Loading schema...

Loading editor...

No results yet

Run a query to see results