MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table `table` (
  id int,
  man_id int,
  year int,
  house_id int
);
insert into `table`
values(1, 10, 2012, 1),
      (2, 14, 2011, 5),
      (3, 12, 2010, 4),
      (4, 10, 2010, 3),
      (5, 15, 2013, 1),
      (6, 12, 2012, 3);

Records: 6  Duplicates: 0  Warnings: 0


select
  *
from `table` as a
where a.house_id = 3 and
      not exists(
            select
              *
            from `table` as b
            where a.man_id = b.man_id and
                  a.house_id != b.house_id and
                  a.year < b.year
          );


id
man_id
year
house_id


6
12
2012
3


insert into `table` values(7, 12, 2019, 42)
;
select
  *
from `table` as a
where -- house_id = 3 and
      not exists(
            select
              *
            from `table` as b
            where a.man_id = b.man_id and
                  a.house_id != b.house_id and
                  a.year < b.year
          );


id
man_id
year
house_id


1
10
2012
1

2
14
2011
5

5
15
2013
1

7
12
2019
42