Problem: Compute Student CGPA
Explore how to calculate each student's CGPA by averaging their semester GPAs using SQL. Understand grouping and aggregation functions to work with multiple tables and retrieve meaningful academic insights.
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: ...
ID | Name | Class |
1001 | James | 9A |
1002 | Olivia | 9A |
1003 | Ethan | 9B |
1004 | Sophia | 9A |
1005 | Liam | 9B |
...