Using a semi$-$join, determine all the People who are fathers.

Is this a SEMI$-$Join?

SELECT DISTINCT Father.Name

FROM Person Father

JOIN Parent ON Father.PersonID $=$ Parent.ParentID

WHERE Father.Gender$=\text{'}$M$\text{'}$

Order BY Father.Name;

Using an anti$-$join, determine all of the unwed people.

SELECT Person.Name

FROM Person

LEFT JOIN Spouse ON Person.PersonID $=$ Spouse.Spouse$1$ OR Person.PersonID $=$ Spouse.Spouse$2$

WHERE Spouse.Spouse$1$ IS NULL;

How do I fix this code to get an Answer back??