How to display the minimum price in a group?

Question

Ruby on Rails

I read here rusrails.ru/active-record-query-interface 7th point, but I didn’t understand something ....
There is a Room model. They have a plan_id parameter. You need to group them by plan_id and display the cheapest one from the group.
Right now I'm doing this: Room.order(price: :asc).group("plan_id"). If you put desc, then it displays the most expensive one, and if asc, then the logic is not clear at all. As I understand it, somewhere you need to specify min (price) somewhere, but I don’t understand where and how.
Help, people! Thanks in advance)

Answer 1

www.sql.ru/forum/687908/faq-vyborka-pervoy-posledn...

Answer 2

Room.group(:plan_id).minimum(:price)