SQLize Online / PHPize Online  /  SQLtest Online

SELECT LEFT(seat_no, -1)::NUMERIC AS row, JSON_AGG(RIGHT(seat_no, 1) ORDER BY RIGHT(seat_no, 1)) AS seats, fare_conditions FROM seats WHERE aircraft_code = (SELECT aircraft_code FROM aircrafts_data WHERE model->>'en' = 'Boeing 777-300') GROUP BY row, fare_conditions ; select * from query_cost('SELECT LEFT(seat_no, -1)::NUMERIC AS row, JSON_AGG(RIGHT(seat_no, 1) ORDER BY RIGHT(seat_no, 1)) AS seats, fare_conditions FROM seats WHERE aircraft_code = (SELECT aircraft_code FROM aircrafts_data WHERE model->>''en'' = ''Boeing 777-300'') GROUP BY row, fare_conditions ');