How to do complex arithmetic in psql console?

Question

PostgreSQL

Please tell me how to do something like in psql

select (select sum(price) from spends) as total, (select max(time)-min(time) from spends) as period, total/period from spends

?

Answer 1

with to help you :-)

Answer 2

Do you really want us to read this one line sql centipede?