Student Database

Tables: Students, Courses, Enrollments, Grades.

Tasks: Average marks per course, topper in each subject, failed students.

SELECT c.CourseName, AVG(g.Marks) AS AvgMarks
FROM Courses c
JOIN Grades g ON c.CourseID = g.CourseID
GROUP BY c.CourseName;