Table $4-22$ Summary of Major Error Types in Query Formulation

Identify errors in the following SQL statement. For each error, you should indicate the

error type as specified in Table $4-22.$ Correct the statement and document its purpose.

SELECT CustState, AVG $($CustBal$)$ AS AvgBal,

COUNT $(*)$ AS NumCustomers

FROM Customer

WHERE CustBal $>100$;