Important fields that will be needed $($to save space I used "abbreviations" that should NOT be used in actual programming$)$:

tblCustomer:

CustomerNumber $[$I put it as "CustNum" $-$

JUST for this exam$]$

SalesRepNumber $[$I put it as "RepNum" $-$ JUST

for this exam$]$

tbISIsrep:

SalesRepNumber $[$I put it as "RepNum" $-$ JUS $]$ for this exam$]$

CommissionRate $[$I put it as "ComRate" $-$ JUS for this examl

SQL$-8.$ Based on the above table, identify the customer $($Name$,$ State$)$ who has a balance at least $10\%$ hi the average balance in their own state.

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

$($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$)$;

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

$($SELECT AVG$($Balance$)$ FROM