Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate…?

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?

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?

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 0

Your email address will not be published. Required fields are marked *