PrepAway - Latest Free Exam Questions & Answers

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?

PrepAway - Latest Free Exam Questions & Answers

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);


Leave a Reply