$($SELECT AVG$($Balance$)$ FROM tblCustomer WHERE State $=$ Cust.State GROUP BY State$)$;

SELECT Name, State FROM tblCustomer C WHERE balance ${1\mathrm{.}1}^{**}$

$($SELECT AVG$($Balance$)$ FROM Cust WHERE State $=$ Cust. State GROUP BY State$)$;

D

All of the above can do the job

Next question requires the WRITING of SQL code. It is the most complex question; difficulty with this question does NOT indicate a failure: most students are expected NOT being able to solve it $($even so they would only lose $4$ base points$).$

SQL$-9.(4$ base $+6$ extra points$).$ Based on the above table, identify the customer $($Name$,$ City$)$ who are NOT in the same city as their manager $($list manager's name and city too$)$ and who has the balance $10\%$ or more lower than the everage of their own city. For this question, write the SQL code below $($not multiple choice$)$: