How can I select data from a database based on an arithmetic condition in Ruby on Rails?

Question

Ruby on Rails

For example, there is a Table1 table, and there are price and price_paid fields.
I want to select items where at price - price_paid > 0.
How can I do this?

Answer 1

Very simple:
YouModel.where("price - price_paid > 0")