Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?
Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?
The correct SQL statement to return the Customers2 relation from the Customers relation is: SELECT * FROM Customers WHERE Satisfaction_Rate >= 80 AND Satisfaction_Rate <= 89. The Customers2 relation includes records where the Satisfaction_Rate is between 80 and 89 inclusive (85 and 81 in this case). The options that involve satisfaction rates of exactly 80 or 90, or using the BETWEEN syntax without proper boundaries, are incorrect.
c is the answer