query on query

Hi,

I have a table like this –

postgres=# \d m

       Table "public.m"

Column |  Type   | Modifiers

--------+---------+-----------

id     | integer |

marks  | integer |

postgres=# select * from m;

id | marks

----+-------

  1 |    27

  2 |    37

  3 |    17

  4 |    27

  5 |    18

(5 rows)

I wanted to get cumulative counts of students in different ranges – >90, > 80  , > 70  etc.

>10  5

>20  3

>30  1

>40 0

> 50 0

So each student may get counted many times, someone with 99 will be counted 10 times. Possible to do this with a fat query? The table will have many thousands of records.

Regards,

Jayadevan