How to do a sum query

[patcito]

What would be the recommended way to do a sum query such as select sum(amount) from deposits?

Thanks,

-Patrick

[steve-chavez]

Hey @patcito,

You can create a view for that:

CREATE VIEW deposits_sum AS
SELECT sum(amount)
FROM deposits

Then you can call the view through supabase-js, same as any other table.