i have a table socitymain .it's some row given here..........
here i display few row for example but really data is more than 1000 row...
--------------------------------------------------------------------
| id | socityname | house | population | areaofsocity |
| 1 | abcd | 10 | 150 | 10 |
| 2 | cdf | 5 | 15 | 20 |
| 3 | zxc | 20 | 20 | 10 |
| 4 | bnmc | 98 | 10 | 30 |
|
|
|
|
|
i want result the area's range wise socity count,population sum ,house sum
like......
| values | 0to10 | 11to20 | 21to30 | 31up |
|
|
|
|
| socity | 2 | 1 | 1 |
|
|
|
|
|
| house | 30 | 5 | 98 |
|
|
|
|
|
| population | 170 | 15 | 10 |
|
|
|
|
|