with asst as (SELECT count(P.id) as pid, S.class as class, P.id as plid
FROM Planet PSELECT 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;