#1
(SELECT COUNT(t.ticket_id) FROM tickets AS t
    GROUP BY t.flight_id
    HAVING OLD.flight_id = t.flight_id)    - Ne minava 1 test

#2
(SELECT COUNT(t.ticket_id) FROM tickets AS t
WHERE t.flight_id=OLD.flight_id)  -Minava