SELECT (sum(marks_subject)*100)/1000 AS percentage_marks FROM STUDENT_MARKS WHERE student_name = 'X'; The above SQL query will provide student X's cumulative percentage (combined) in all subjects. To calculate the percentage of two columns we follow the same except that we use appropriate columns.