问我怎样才能在postgres 12中扮演jsonb？

EN

select
    id,
    cast((nd ->> 'bath') as float) as bath,
    cast((nd ->> 'bed') as integer) as bed,
    cast(ndp as NUMERIC) as price ,
    FIRST_VALUE(cast((nd ->> 'bed') as integer)) OVER(
ORDER BY
    cast((nd ->> 'bed') as integer)) priority_bed,
    FIRST_VALUE(cast((nd ->> 'bath') as float)) OVER(
ORDER BY
    cast((nd ->> 'bath') as float)) priority_bath 
FROM
    properties p cross 
join
    lateral jsonb_array_elements(p.bed_bath_price) as nd cross 
join
    lateral jsonb_array_elements(nd -> 'price') as ndp