SQL से Fee Summary Query

लक्ष्य

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 दिखे।