Program to Calculate Sum and Average

PROGRAM TO CALCULATE SUM AND AVERAGE OF ‘N’ NATURAL NUMBERS

SQL >Ed sumandAvg.SQL

Declare

I number: = 1;

N number: = &n;

Sum number;

Avg number;

Begin

While(i<=n)

Loop

Sum ≔ sum + i;

i = i + 1;

End loop;

Avg := sum/n:

Dbms-output.Put_Line (‘sum of natural no’ s || (sum)];

Dbms_output.Put_line(‘Average is || (avg);

End;

Output

N=10

Sum of natural no’s 55

Average is 5.5