I need a query grouping some data in classes. E.g.:

Having this data
______________
gendre | tall
M | 1.78
F | 1.67
M | 1.75
M | 1.72
F | 1.74
F | 1.57
M | 1.68
F | 1.76
M | 1.90
_______________

make a classes-schema like this:
__________________________________
gendre | tall classes | count(gendre)
F |da 1,60 a 1,70 | 1
F | da 1,70 a 1,80 | 3
M | da 1,60 a 1,70 | 1
M | da 1,70 a 1,80 | 3
M | da 1,80 a 1,90 | 1
_________________________________

it is possible? Thanks!

regrat wrote:

Excuse me while I Americanize it and fix your spelling and use 'Height'
instead of Tall

SELECT
Gender,
IIf(Height > 1.5 AND Height <= 1.7, '1.5 to 1.7',
IIf(Height >= 1.71 AND Height <= 1.75, '1.71 to 1.75',
IIf(Height > 1.75, 'Above 1.75'))) as HeightGroup,
Count(Height) AS Count

FROM
Table1

GROUP BY
Gender,
IIf(Height > 1.5 AND Height <= 1.7, '1.5 to 1.7',
IIf(Height >= 1.71 AND Height <= 1.75, '1.71 to 1.75',
IIf(Height > 1.75, 'Above 1.75'))) ;


It would be better (more configurable/maintable) for you to have a separate
table containing the height groupings.