I'am facing issue with nested queries , even after simplification of nested sub queries ,its not working ,please help solve this issue.