There are two table Persons and Vaccinations. If we run below query yhe what js the correct answer

Viewed 26
SELECT P.First Name, P. Last Name
FROM Persons AS P 
LEFT OUTER JOIN Vaccinations AS V ON P. Email = V.Recipient 
WHERE V.Comments IS NULL;

Select the correct answer:

a) No rows will be returned

b) A row for each vaccination of persons who never had any comments associated with their vaccinations.

c) A row for each vaccination without comments of persons who were vaccinated, and a row for each person who was not.

d) A row for each person who never had any comments.

0 Answers
Related