-- create
create table marks (STUDENT_ID integer,MARKS integer);

-- insert
INSERT INTO marks (STUDENT_ID,MARKS) VALUES (001, 450);
INSERT INTO marks (STUDENT_ID,MARKS) VALUES (002, 200);
INSERT INTO marks (STUDENT_ID,MARKS) VALUES (003, 260);
INSERT INTO marks (STUDENT_ID,MARKS) VALUES (002, 300);
INSERT INTO marks (STUDENT_ID,MARKS) VALUES (003, 250);

-- fetch 

SELECT STUDENT_ID, SUM(MARKS) AS TOTAL 
FROM marks  
GROUP BY STUDENT_ID  HAVING SUM(marks.MARKS)>=500;