If I understood your question correctly perhaps something like
select
case
when marks > 75 and marks < 90 then grade
else null
end as g1,
case
when marks > 40 and marks <= 75 then grade
else null
end as g2
from student
where marks > 40 and marks < 90