Consider the following relations shown in the exhibit. Which of the following SQL statements would
return the Customers2 relation from the Customers relation?
A.
SELECT * FROM Customers
WHERE Satisfaction_Rate <= 80
OR Satisfaction_Rate >= 90;
B.
SELECT * FROM Customers WHERE
Satisfaction_Rate IN (80 AND 90);
C.
SELECT *FROM Customers
WHERE Satisfaction_Rate >= 80
AND Satisfaction_Rate <= 89;
D.
SELECT * FROM
Customers WHERE
Satisfaction_Rate
BETWEEN (80, 90);