How to make a query in the database so that it turns out like on the screen?

Question

MySQL

There is a price distribution on the chart (see screenshot)


and there are 2 tables: products and options
products : id, name, description
options : id, name, price, product_id

Question - how to implement a similar result so that the query is fast?

Answer 1

Make a calculated column (price_range), where the price will be rounded to tens, say (however, the step can be selected individually). It has an index.
Then select price_range, count(id) from options group by price_range
Well, then draw the chart.