How to write the below query in to ditached criteria?

How to write the below query in to ditached criteria?

Select "answer"
from 'Details'
where "question" like 'child'
AND "subject" IN (select "subject"
from 'Details'
where "question" like 'child'
AND "answer" = "M" and "test" ="1");