Posts by Programmer • 11 points
1 post
-
1
votes0
answers28
viewsQ: Select 2 json information
I have the following select to query in the bank the sum of the values of a given day and group by cardBrand. select SUM (amount::numeric)/100, response ->> 'cardBrand' from fatura where…