Given the table
CUSTOMER(CustID,Name,PhoneNum,AcctBalance)
What is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?
A) WHERE CUSTOMER-AcctBalance 50
B) WHERE (CUSTOMER-AcctBalance 50)
C) WHERE AcctBalance 50
D) WHERE (AcctBalance 50)
E) HAVING AcctBalance 50

Question

Given the table
CUSTOMER(CustID,Name,PhoneNum,AcctBalance)
What is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?
A) WHERE CUSTOMER-AcctBalance > 50
B) WHERE (CUSTOMER-AcctBalance > 50)
C) WHERE AcctBalance > 50
D) WHERE (AcctBalance > 50)
E) HAVING AcctBalance > 50

Quizplus · Accepted Answer

The correct SQL query phrase to filter rows based on a condition is "WHERE". The correct syntax to check if the AcctBalance is greater than 50 is "WHERE AcctBalance > 50".

Given the Table CUSTOMER(CustID,Name,PhoneNum,AcctBalance)