i have a table socitymain which has some value like..................
id | socityname | house | population | areaofsocity
1 | abcd | 10 | 150 | 10
2 | cdf | 5 | 15 | 20
3 | zxc | 20 | 20 | 10
4 | bnm | 98 | 10 | 30
. . . . .
. . . . .
n n n n n
i want reslut sum of socityid,sum of hpuse,sumof population in range of areawise like this..............
values | 0to10 | 11to20 | 21to30 | 31up
socity | 2 | 1 | 1 |
house | 30 | 5 | 98 |
population | 170 | 15 | 10 |