> On Dec 19, 2019, at 7:45 PM, No.1 Perfect <[hidden email]> wrote:
> How can I count the amount and num of goods when the customer or goods name is different.
Querying the contents of arrays is kind of complicated. SQL doesn't understand arrays, so the query has to use a "table-valued function", json_each, that makes the array appear to be a table where each item is a row. Then you can use a JOIN to query that "table".