with asst as (SELECT count(P.id) as pid, S.class as class, P.id as plid

SELECT id AS flight_id, name AS commander_name, pax_count FROM (

   SELECT F.id, COUNT(P.id)::INT AS pax_count, C.name

   FROM Flight F

   JOIN Commander C ON F.commander_id=C.id

   JOIN Booking B ON B.flight_id = F.id

   JOIN Pax P ON B.pax_id=P.id

   WHERE P.race='Men'

   AND F.date BETWEEN '2084-04-01' AND '2084-05-01'

   AND C.name = 'Ким'

   GROUP BY F.id, C.name

) T WHERE T.pax_count>1;