SQLize | PHPize | SQLtest

SELECT (SELECT COUNT(s.seat_no) FROM seats s WHERE s.aircraft_code = f.aircraft_code) AS total_seats, COUNT(b.seat_no) AS occupied_seats -- Считаем количество выданных посадочных талонов FROM flights f INNER JOIN boarding_passes b ON f.flight_id = b.flight_id WHERE -- f.flight_no = '30625' GROUP BY f.flight_id, f.aircraft_code; ; select * from query_cost('SELECT (SELECT COUNT(s.seat_no) FROM seats s WHERE s.aircraft_code = f.aircraft_code) AS total_seats, COUNT(b.seat_no) AS occupied_seats -- Считаем количество выданных посадочных талонов FROM flights f INNER JOIN boarding_passes b ON f.flight_id = b.flight_id WHERE -- f.flight_no = ''30625'' GROUP BY f.flight_id, f.aircraft_code;');