How to write select Statement based on score column result using SQL seerver?
===

Actually my requirement is sothing like below
I need to get student details with score and result
**Condition:**
if score is more than 70 then result will be pass or else fail
score column can get from DB based on score need to find out result



