Say I have a table of real estate properties:
A 15,000 B 50,000 C 100,000 D 25,000
I'd like to group them by 0 - 49,999, 50,000 - 99,999 and 100,000 - 200,000
So the result should be:
0 - 49k (2) 50k - 99k (1) 100k - 200k (1)
Is there a way to do that in one SQL statement? I'm using Postgres by the way.
GROUP BY an experession, something like that:
SELECT price/50000*50000 AS minPrice, (price/50000+1)*50000-1 AS maxPrice, COUNT(*) FROM table GROUP BY price/50000;