MySQL Selection Query

[pacchiee]

Hello,

 

I have a table with the following structure and entries:

 

id|score1|score2|grade

1|90|100|A

2|75|89|B

3|60|74|C

4|40|59|D

5|0|39|E

 

Now, given a score how can I fetch the grade?

 

Example: Given score as 85, I should fetch 'B'.

 

Or is that I need to change the structure of the table altogether? Am new to MySQL; please help.

 

Thanks in Advance!

[Mchl]

SELECT grade FROM table WHERE score1 <= 85 AND score2 >= 85