Students Above Class Average

Write a SQL query to find students who scored above their class average in Mathematics.

Expected Columns

• student_name
• class
• marks
• class_avg

Example Output

| student_name | class | marks | class_avg | |--------------|-------|-------|-----------| | Ishaan Malhotra | 10 | 92 | 80.4 | | Shreya Pillai | 10 | 95 | 80.4 | | ... | ... | ... | ... |