SET ENGINEBEHAVIOR  70 

CREATE CURSOR TableStudents (idstudents I, flastname C( 20 )) 
INSERT INTO TableStudents (idstudents, flastname) VALUES ( 10 , 'Иванов')
INSERT INTO TableStudents (idstudents, flastname) VALUES ( 20 , 'Петров')
INSERT INTO TableStudents (idstudents, flastname) VALUES ( 30 , 'Сидоров')
INSERT INTO TableStudents (idstudents, flastname) VALUES ( 40 , 'Козлов')
INSERT INTO TableStudents (idstudents, flastname) VALUES ( 50 , 'Пупкин')


CREATE CURSOR TableMark (idstudents I, idvariant I, idmark I) 
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 10 ,  1 ,  3 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 10 ,  2 ,  3 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 10 ,  3 ,  3 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 10 ,  4 ,  3 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 10 ,  5 ,  3 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 20 ,  1 ,  4 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 20 ,  2 ,  4 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 20 ,  3 ,  4 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 20 ,  4 ,  4 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 20 ,  5 ,  4 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 30 ,  1 ,  5 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 30 ,  2 ,  5 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 30 ,  3 ,  5 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 30 ,  4 ,  5 )
INSERT INTO TableMark (idstudents, idvariant, idmark) VALUES ( 30 ,  5 ,  5 )


SELECT TableStudents.flastname, SUM(TableMark.idmark) as fsum ;
  FROM TableMark ;
  INNER JOIN TableStudents ON TableMark.idstudents=TableStudents.idstudents ;
  GROUP BY TableMark.idstudents ;
  INTO CURSOR res
  
BROWSE