Untitled

delimiter //
create procedure proc_Grade(IN marks int, IN std_name varchar(20), IN roll int)
begin
	IF (marks>=990 and marks<=1500) then
		insert into Result values (std_name, roll, 'distinction');
		
	else if (marks>=900 and marks<=989) then
		insert into Result values (std_name, roll, 'first class');
		
	else if (marks>=825 and marks<=899) then 
		insert into Result values (std_name, roll, 'higher second class');  
		
	else if (marks>=650 and marks<=824) then 
		insert into Result values (std_name, roll, 'second class');  
		
	else if (marks>=500 and marks<=649) then
		insert into Result values (std_name, roll, 'pass'); 
		
	else if (marks<500) then 
		insert into Result values (std_name, roll, 'fail'); 
        END IF;
end //
delimiter ;