'Can't join the resullts

I want to find out all the employees who have the same number of children as the employees of department 111 and who were born between the years 1968 and 1969. So if in the department I have employees who have 1 and 2 children, the result of the query should be all the employees born on that date and who have 1 and 2 children

With this query i find out employees born in those years

select * 
from temple 
where fecna between '1968-01-01' and '1969-12-31';

Result of the query

And here I find out all types of number of children in department 111

select distinct numhi 
from temple 
where numde = 111;

Result of the query

The result should be something like this

Expected result

I tried to join both select but returns wrong data



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source