You work as a database administrator at ABC.com. You study the exhibit carefully. Exhibit:
Evaluate the following query: Exhibit: The above query produces an error on execution.
What is the reason for the error?
A.
An alias cannot be used in an expression
B.
The alias MIDPOINT should be enclosed within double quotation marks for the
CUST_CREDIT_LIMIT/2 expression
C.
The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains
NULL values
D.
The alias NAME should not be enclosed within double quotation marks