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) WHERE Satisfaction_Rate = 80; D) WHERE Satisfaction_Rate = 80 AND NOT Sales Office = Atlanta

Question

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) WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta 
C) WHERE Satisfaction_Rate >= 80; 
D) WHERE Satisfaction_Rate >= 80 AND NOT Sales Office = Atlanta

Quizplus · Accepted Answer

The Answer of 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) WHERE Satisfaction_Rate <= 80 AND Sales_Office = Atlanta 
C) WHERE Satisfaction_Rate >= 80; 
D) WHERE Satisfaction_Rate >= 80 AND NOT Sales Office = Atlanta

Consider the Relation Shown in the Exhibit