I have a parent entity Contact and child entity employment.
I want to select contact name,
who has atleast 1 employment record with Comany "XXX" and atleast 1 employment record with out company "XXX"
Please help to write SQL Query