set role u3952239_CourseManagers;

--select * from OPS$U3952239.AssignmentSummary;
--select * from OPS$U3952239.Tutorial;
--select * from OPS$U3952239.AssessmentItem;
--select * from OPS$U3952239.Student;
--select * from OPS$U3952239.Mark;

--delete from OPS$U3952239.Mark
--where StudentId = 2010999
--and AId = 'a3';

--select * from OPS$U3952239.Mark;

--select * from OPS$U3952239.FinalMark;

--update OPS$U3952239.Mark
--set AMark = 82
--where AId = 'exam'
--and StudentId = 2010123;

--select * from OPS$U3952239.FinalMark;

update OPS$U3952239.Student
set TutId = '&TutId'
where StudentId = &StudentId
and TutId in
    select TutId, count(StudentId) as Number from OPS$U3952239.Student
    where P < 19
    group by TutId;