Student Information to Calculate Grade

ACCEPT STUDENT NUMBER, MARKS IN DIFFERENT SUBJECTS TO CALCULATE THE TOTAL MARKS AND AVERAGE.  

ALSO PRINT THE RESULT AS IF ANY SUBJECT MARKS ≤ 35 FAIL, AVG ≥ 60 1^ST CLASS, AVG > 502 2^ND CLASS, OTHERWISE 3^RD CLASS.

SQL >Ed stu . SQL

Declare

SNO number:= & sno;

M1 number:=& m1;

M2 number: =& m2;

Total number;

Avg number;

Grade varchar 2(10);

Begin

Total= m1+m2:

Avg:=total/2;

If (M1< 35 or (M2 < 35) then

Grade=’fail’;

Else if (avg>=60) then

Grade:= ‘first’;

Else if (avg>=50 ) then

Grade:= ‘second’;

Else

Grade:= ‘third’;

End if

Dbms-output. Put.line(‘grade is’||  grade);

End;

Output

SNO=9458

M1=45

M2=60

Total=105

Avg=54.5

Grade =second.