Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2
Posted: Sat Jul 23, 2022 7:29 pm
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);
- Consider The Fo 1 (191.72 KiB) Viewed 60 times
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);