Query single col into several cols result set

Hello,

I have a table with 1 column containing numeric values, and I need to create a query which displays the count of values for each set of conditions. For example, if the table contains the values 1,2,3,4,5 and 6, the output of the query should look like this:

L M H
-----------------------
3 2 1

(L are values below 4, M between 4 and 5, H is 6 and above)

Any suggestions?

TIA

write an application program, this will be almost impossible to do in sql

better yet, redesign the table so that the column has only one value in it (this is called first normal form and you may find more information on it by googling)