SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
SELECT row, json_agg(seat_number ORDER BY seat_number) AS seats, fare_conditions FROM plane_seats WHERE aircraft_code = 'Boeing 777-300' GROUP BY row, fare_conditions ORDER BY row

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear