How to retrieve the resultset for the range-in numbers

[sathishgsql]

Hi Friends!

Nice to meet you all in this forum.

Would like to know the logic or the solution for the below query.

The query is,want to get the resultset for the range-in numbers.Mean by there are several sections for each class in a school.

Would like to retrieve how many students score above 50,50-75,75-90,above 90 based on each sections.

N.B: User input each student record based on the class-wise,but get the result in the below format

CLASS - 10TH
SUBJ - ENGLISH
TOTAL STUDENT - 45
BELOW 50 - 7
50-75 - 25
75-90 - 10
ABOVE 90 - 3

If anyone across this problem or know the solution just pass on.Any help in this issue are appericiated.

[MAK]

http://forums.databasejournal.com/sh...threadid=36280