Problem: Compute Student CGPA
Understand how to calculate each student's CGPA by averaging their semester GPAs across multiple semesters. Learn to use SQL aggregation functions like AVG and GROUP BY to analyze educational data, and practice rounding results for clear reports.
We'll cover the following...
We'll cover the following...
In this project, you’ll compute each student’s CGPA (Cumulative Grade Point Average) based on their SGPA across multiple semesters. This is a common real-world use case in education analytics and reporting systems.
Database schema
You’ll work with these two tables: ...