Sorting on a nested field in a jsonb object whose parent key can be multiple values

I have a field that is of type jsonb that is structured like:

How can i resolve this error on my postgresql database, error: invalid input syntax for type integer: ” “

eror: invalid input syntax for type integer: ” ”
How can i resolve this error on my postgresql database?

JSONB_ARRAY_ELEMENTS expansion. How does it work?

I cannot grasp how the JSONB_ARRAY_ELEMENTS function works and why it expands the rows the way it does.

Postgres JSONB concat object values in array

I have a table

Postgres jsonb: How to get mongo like projections?

I have a jsonb column containing data like this:

Query and return aggregate from a jsonb column in postgresql 14+

Is there an efficient way to aggregate data from a jsonb column in postgresql? Given the table