select p1.name, p1.gender, p2.name, p2.gender, p1.species
from pet as p1, pet as p2
where p1.species = p2.species and p1.gender = 'f' and p2.gender = 'm'
and p1.death is null and p2.death is null;
select us.user_pname, pr.project_desc
from wf_project as pr, wf_promnger as prm, wf_unit as un, wf_unitmnger as unm, wf_empmatrix as emp, user as us
where prm.prmng_code=0 and prm.prmng_code=us.user_code