Observe this table.    The above query produces an error on execution. What is the reason for the error?Select one:a.The alias MIDPOINT should be enclosed within double quotation marks for the CUST_CREDIT_LIMIT/2 expressionb.An alias cannot be used in an expressionc.The MIDPOINT +100 expression gives an error because CUST_CREDIT_LIMIT contains NULL valuesd.The alias NAME should not be enclosed within double quotation marks

In the given SQL query, what purpose do the aliases serve?

Review this SQL Statement: SELECT ename, emp_number, salary FROM employee WHERE dept_number = (SELECT dept_number FROM department WHERE location IN('CHICAGO','ATLANTA')); Why may this statement return an error?

SQL will default to a field name if no alias is specified when performing arithmetic. Select the correct default field name that would appear. Select the correct answer

Question 4Fill in the blank: Aliasing involves _____ naming a table or column to make a query easier to read and write.

The keyword used to create an alias in MySQL is .............