BEGIN
declare @min numeric(18,0);
declare @max numeric(18,0);
declare @avg numeric(18,0);   
declare @tmp numeric(18,0);
declare @cnt numeric(18,0);
declare @sum numeric(18,0);

declare my_cursor cursor
for select price from Books;

OPEN my_cursor

fetch next from my_cursor into @tmp;

set @max=@tmp;
set @min=@tmp;
set @avg=@tmp;
set @cnt=1;
set @sum=@tmp;

while @@fetch_status=0
BEGIN
fetch next from my_cursor into @tmp;
    if @tmp>@max
    begin
    set @max=@tmp;
    end
    if @tmp<@min
    begin
    set @min=@tmp;
    end
    set @cnt=@cnt+1;
    set @sum=@sum+@tmp;
end
close my_cursor;
deallocate my_cursor;
set @avg = @sum/@cnt;
print 'max ='+STR(@max);
print 'min ='+STR(@min);
print 'avg ='+STR(@avg);
END