MySQL Views and Stored Procedures

CREATE VIEW student_stats AS
SELECT s.name,
       COUNT(e.id) AS total_courses,
       ROUND(AVG(e.score), 1) AS avg_score
FROM students s
LEFT JOIN enrollments e ON s.id = e.student_id
GROUP BY s.id, s.name;

SELECT * FROM student_stats WHERE avg_score > 80;

DELIMITER //
CREATE PROCEDURE get_top_students(IN min_score INT)
BEGIN
    SELECT s.name, AVG(e.score) AS avg_score
    FROM students s
    JOIN enrollments e ON s.id = e.student_id
    GROUP BY s.id, s.name
    HAVING AVG(e.score) >= min_score
    ORDER BY avg_score DESC;
END //
DELIMITER ;

CALL get_top_students(80);