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 following relations shown in the exhibit. Which of the following SQL statements would return the Customers2
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!