SQLize Online / PHPize Online  /  SQLtest Online

SELECT row, json_agg(seat_letter ORDER BY seat_letter) AS seats, fare_conditions FROM ( SELECT row as seat_no, FROM seats WHERE seat_letter IN ('A', 'B', 'C', 'H', 'J', 'K') and aircraft_code = "773" ) AS filtered_seats GROUP BY row, fare_conditions ORDER BY row; ; select * from query_cost('SELECT row, json_agg(seat_letter ORDER BY seat_letter) AS seats, fare_conditions FROM ( SELECT row as seat_no, FROM seats WHERE seat_letter IN (''A'', ''B'', ''C'', ''H'', ''J'', ''K'') and aircraft_code = "773" ) AS filtered_seats GROUP BY row, fare_conditions ORDER BY row;');