What is the reason for the error?

View the Exhibit and examine the data in the CUSTOMERS table.
Evaluate the following query:
The above query produces an error on execution.
What is the reason for the error?

View the Exhibit and examine the data in the CUSTOMERS table.
Evaluate the following query:
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 a lias NAME should not be enclosed with in double quotation marks .

C.
The MIDPOINT+100 expression gives an error because CUST_CREDIT_LIMIT contains NULL values.

D.
The a lias MIDPOINT should be enclosed with in double quotation marks for the CUST_CREDIT_LIMIT/2
expression .



Leave a Reply 0

Your email address will not be published. Required fields are marked *