Report Card Query Using SQL

Goal

The Query

SELECT s.name,
       SUM(m.score) AS total,
       ROUND(AVG(m.score), 1) AS percentage,
       CASE WHEN AVG(m.score) >= 90 THEN 'A+'
            WHEN AVG(m.score) >= 75 THEN 'A'
            WHEN AVG(m.score) >= 33 THEN 'Pass'
            ELSE 'Fail' END AS grade
FROM students s JOIN marks m ON s.roll_no = m.roll_no
GROUP BY s.name;

Summary

• JOIN + GROUP BY totals each student; AVG gives percentage.
• CASE turns the percentage into a grade in the same query.

लक्ष्य

Query

SELECT s.name,
       SUM(m.score) AS total,
       ROUND(AVG(m.score), 1) AS percentage,
       CASE WHEN AVG(m.score) >= 90 THEN 'A+'
            WHEN AVG(m.score) >= 75 THEN 'A'
            WHEN AVG(m.score) >= 33 THEN 'Pass'
            ELSE 'Fail' END AS grade
FROM students s JOIN marks m ON s.roll_no = m.roll_no
GROUP BY s.name;

सारांश

• JOIN + GROUP BY हर student का total; AVG percentage देता है।
• CASE उसी query में percentage को grade में बदल देता है।