In this question, it is asked to retrieve the name of each employee who has a dependent with the same first name and is the same sex as employee.
How Q1 will give the correct result, coz inside IN() the condition Essn=D,Essn is not there. Can anybody explain.
