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

data: {
  "prices": {
    "[parent key]": {
        "price": 20,
    }
  }
}

‘parent key’ can be 5 possible values but all I really need is the ‘price’ field. Ultimately I would like to extract that price field as well as order the results by that field. Is there a way that this can be done?