One way to do this is to use the 'CASE' expression, documented here:
http://pgsql.dbexperts.com.br/devel-corner/docs/postgres/functions-conditional.html
Because you have only one record per person, you can use the 'COUNT'
aggregate function to see how many of each height category match. An
examp
From: "Txugo" <[EMAIL PROTECTED]>
> I have a table where one record represent a person, including his height.
> I'd like to know how many person have more than 150 cm, more than 160 cm
> and so on.
> How can I do that using SQL?
>
> Example:
> people > 150 - 1000
>> 160 - 850
>>
