How to get the sum of the values ​​produced in each row in a MYSQL query?

Question

MySQL

Let's say we have a table

price | new_price
  10       15
  20       25
  30       35

How to pull out the sum (15-10) + (25-20) + (35-30) with one request?

Answer 1

SUM()

Answer 2

select sum(new_price - price) as total from prices;

Execute SQL query