Fee Summary Query Using SQL

Goal

The Query

SELECT s.name,
       IFNULL(SUM(f.amount), 0) AS total_paid
FROM students s
LEFT JOIN fees f ON s.roll_no = f.roll_no
GROUP BY s.name
ORDER BY total_paid DESC;

Summary

• LEFT JOIN + GROUP BY + SUM builds a per-student fee summary.
• IFNULL turns missing totals into 0 so every student appears.

लक्ष्य

Query

SELECT s.name,
       IFNULL(SUM(f.amount), 0) AS total_paid
FROM students s
LEFT JOIN fees f ON s.roll_no = f.roll_no
GROUP BY s.name
ORDER BY total_paid DESC;

सारांश

• LEFT JOIN + GROUP BY + SUM per-student fee summary बनाता है।
• IFNULL missing totals को 0 करता है ताकि हर student दिखे।