SQLize Online / PHPize Online  /  SQLtest Online

select substring(seat_no from '^[0-9]*')::int as row ,json_agg(substring(seat_no from '[A-Z]') order by seat_no) as seats, fare_conditions from seats join aircrafts_data on seats.aircraft_code = aircrafts_data.aircraft_code where aircrafts_data.model->>'en' = 'Boeing 777-300' group by row,fare_conditions order by rowselect ; select * from query_cost('select substring(seat_no from ''^[0-9]*'')::int as row ,json_agg(substring(seat_no from ''[A-Z]'') order by seat_no) as seats, fare_conditions from seats join aircrafts_data on seats.aircraft_code = aircrafts_data.aircraft_code where aircrafts_data.model->>''en'' = ''Boeing 777-300'' group by row,fare_conditions order by rowselect ');