SQL & PL/SQL

select * from std where cno = 'CS 130' and csno= 2 and sfname='Yvonne';


SFNAME SLNAME CNO CSNO AC MARKS
-------------------- -------------------- ------ ---------- -- ----------
Yvonne Williams CS 130 2 PA 77
Yvonne Williams CS 130 2 QZ 92
Yvonne Williams CS 130 2 QZ 76
Yvonne Williams CS 130 2 QZ 99
Yvonne Williams CS 130 2 QZ 99
Yvonne Williams CS 130 2 HW 92
Yvonne Williams CS 130 2 HW 91
Yvonne Williams CS 130 2 HW 74
Yvonne Williams CS 130 2 HW 74
Yvonne Williams CS 130 2 Mi 92
Yvonne Williams CS 130 2 Fi 77

11 rows selected.

Select * from gpol where cno = 'CS 130' and csno= 2;

CNO CSNO GP PTAKEN D
------ ---------- ------------- ---------- -
CS 130 2 Final Exam 30
CS 130 2 Homework 20 Y
CS 130 2 Midterm Exam 20
CS 130 2 Participation 10
CS 130 2 Quiz 20 Y
here D= drop lowest. PTAKEN is the percentage taken. According to these 2 tables I have to drop the lowest score in HW and QZ and find the average of the remaining scores. After that according to the grading policy I have to calculate the grade points. Like this there are many courses and different grading policies.
Any help is really appreciated.
Thanks
Smitha