select * 
from men m
join women_slept_with w using (man_id)
left join car_owned co using (man_id)
where w.slept_rank=1 and co.owned_rank=1

select * 
from men m
join women_slept_with w using (man_id)
left join car_owned co using (man_id)
where w.slept_rank=1 and (co.owned_rank=1 or co.owned_rank is null)

select * 
from men m
join women_slept_with w using (man_id)
left join car_owned co on (m.man_id=co.man_id and co.owned_rank=1)
where w.slept_rank=1

twoplustwo=> select * from person;
 id |  name   | gender 
----+---------+--------
  1 | Bob     | M
  2 | Alice   | F
  3 | Mallory | M
  4 | Carol   | F

twoplustwo=> select * from partners;
 id | person_id | partner_id |        date         
----+-----------+------------+---------------------
  1 |         1 |          2 | 2018-08-01 00:00:00
  2 |         1 |          4 | 2018-08-04 00:00:00
  3 |         2 |          4 | 2018-07-23 00:00:00

twoplustwo=> select * from cars;
 id | person_id |  make  |   model   |    purchase_date    
----+-----------+--------+-----------+---------------------
  1 |         1 | Subaru | Impreza   | 2018-01-01 00:00:00
  2 |         1 | Subaru | Forrester | 2014-09-01 00:00:00
  3 |         2 | Ford   | F-150     | 2003-06-14 00:00:00
  4 |         3 | Toyota | Camry     | 2013-05-05 00:00:00

WITH ranked_partners AS (
    SELECT *,  RANK() OVER (PARTITION BY person_id ORDER BY date) as rank
    FROM partners
),

ranked_cars AS (
    SELECT *,  RANK() OVER (PARTITION BY person_id ORDER BY purchase_date) as rank
    FROM cars
)

SELECT p.id, p.name, p.gender,
    rp.partner_id as partner_id, sp.name as partner_name, 
    rp.date as partner_date, 
    rc.make, rc.model, rc.purchase_date
FROM
    person p
JOIN ranked_partners rp ON (rp.person_id=p.id AND rp.rank=1)
JOIN person sp ON (sp.id=rp.partner_id)
LEFT JOIN ranked_cars rc ON (rc.person_id=p.id AND rc.rank=1)
WHERE p.gender='M';

 id | name | gender | partner_id | partner_name |    partner_date     |  make  |   model   |    purchase_date    
----+------+--------+------------+--------------+---------------------+--------+-----------+---------------------
  1 | Bob  | M      |          2 | Alice        | 2018-08-01 00:00:00 | Subaru | Forrester | 2014-09-01 00:00:00