select name,

case

when maths > science and maths > comp then 'maths'

when comp > science and comp > maths then 'comp'

else 'science'

end

from student