To retrieve only those records that include people who have served on the board of trustees or on the board of directors, what is the correct query?

You finish cleaning your datasets, so you decide to review Tayen’s email one more time to make sure you completed the task fully. It’s a good thing you checked because you forgot to identify people who have served on the board of directors or board of trustees. She wants to write them a thank-you note, so you need to locate them in the database.

To retrieve only those records that include people who have served on the board of trustees or on the board of directors, what is the correct query?

1 / 1 point

SELECT * FROM Donation_Form_List WHERE Board_Member = TRUE AND Trustee = TRUE

SELECT * FROM Donation_Form_List WHERE Board_Member = “TRUE” OR Trustee = “TRUE”

SELECT * FROM Donation_Form_List WHERE Board_Member = TRUE, Trustee = TRUE

SELECT * FROM Donation_Form_List WHERE Board_Member = “TRUE” AND Trustee = “TRUE”

Correct
To retrieve only those records that include people who have served on the board of trustees or on the board of directors, the correct WHERE statement is:

Related Questions & Answers: