Consider a database which contains people and their respective residence histories:

Which of the following queries will return all the people that have never lived in Boston? Select all that apply.

SELECT p$.*$

FROM people p

JOIN residence$\_$history $r$ ON p$.$person$\_$id $=$ r$.$person$\_$id

WHERE r$.$city $>$ 'Boston'

SELECT p$.*$

FROM people p

LEFT JOIN residence$\_$history $r$ ON p$.$person$\_$id $=$ r$.$person$\_$id

WHERE r$.$city $>$ 'Boston'

SELECT p$.*$

FROM people p

WHERE NOT EXISTS

$($

SELECT $*$

FROM residence$\_$history $r$

WHERE p$.$person$\_$id $=$ r$.$person$\_$id AND city $=$ 'Boston'