The question was how to grade the students according to the total marks.
sel ,stu_id,
CASE WHEN marks>=400 THEN 'GRADE_A'
WHEN marks>300 AND marks < 400 THEN 'GRADE_B' WHEN marks>250 AND marks < 300 THEN 'GRADE_C' ELSE 'FAIL' END
sel ,stu_id,
CASE WHEN marks>=400 THEN 'GRADE_A'
WHEN marks>300 AND marks < 400 THEN 'GRADE_B' WHEN marks>250 AND marks < 300 THEN 'GRADE_C' ELSE 'FAIL' END
Post a Comment