How to calculate Total exam and display grade

Question

I wanna to calculate the total marks of examination table and also to display the grade for example 100 A 89 B and finally show the GPA of the students Please help me

Sanwar Ranwa · Answer

Hello You can add both column value and display it into a new column like SELECT TOP 1000 [Sno] ,[IDNumber] ,[StudentName] ,[Class] ,[AcademicYear] ,[Semester] ,[CourseCode] ,[CourseTitle] ,[CreditHour] ,[CourseType] ,[Attendance] ,[Assigment] ,[MidExam] ,[FinalExam] ,[TotalMarks] ,[Date] ,[DoneBy], +TotalMarks+' '+grade as Total score FROM [OnlineExam].[dbo].[Examination] Or if you want to find grade based on number then use this query SELECT TotalMark, (IF(TotalMark > 84.5, 'A', IF (TotalMark > 64.5, 'B', IF(TotalMark > 49.5, 'C', IF (TotalMark > 29.5, 'D', 'E'))))) AS Grade FROM Results

Abdurahman Yusuf Abdi · Answer

SELECT TOP 1000 [Sno] ,[IDNumber] ,[StudentName] ,[Class] ,[AcademicYear] ,[Semester] ,[CourseCode] ,[CourseTitle] ,[CreditHour] ,[CourseType] ,[Attendance] ,[Assigment] ,[MidExam] ,[FinalExam] ,[TotalMarks] ,[Date] ,[DoneBy] FROM [OnlineExam].[dbo].[Examination] that is my examination table then i want to add another column like Total marks Grade taht two column thank you

Amit Gupta · Answer

It would be much helpful if you have been provide the input table, your logic to calculate grade and the expected output