Find out the sum of all the elements in json array in mysql with filtering
I am using mariadb version 10.2.43-MariaDB-1:10.2.43+maria~bionic Table schema The table has a column features of type JSON with id attribute and details array with the following two rows of data : { "id": 9, "details": [ { "amount": 100, "flag":…