Câu 29: 1D0-541: CIW v5 Database Design Specialist

Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?

1. A. SELECT * FROM Customers WHERE Satisfaction_Rate = 90;
2. B. SELECT * FROM Customers WHERE Satisfaction_Rate IN (80 AND 90);
3. C. SELECT *FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89; — đáp án hiện tại
4. D. SELECT * FROM Customers WHERE Satisfaction_Rate BETWEEN (80, 90);