PrepAway - Latest Free Exam Questions & Answers

Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_

Consider the relation shown in the exhibit.

Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT * FROM Customers
WHERE Satisfaction_Rate > 80
OR Sales_Office = Atlanta

B.
SELECT * FROM Customers
WHERE Satisfaction_Rate <= 80
AND Sales_Office = Atlanta

C.
SELECT * FROM Customers
WHERE Satisfaction_Rate >= 80;

D.
SELECT * FROM Customers
WHERE Satisfaction_Rate >= 80
AND NOT Sales Office = Atlanta


Leave a Reply