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" $-$ JUST for this exam$]$

CommissionRate $[$I put it as "ComRate"

$-IST$ for this exam$]$

SQL$-6.$ Display the average balance $($name it AvgBal$)$ for those states $($so display state$)$ whose average balance is higher than the average balance of all customers. Display also the average of the whole table under the header AllAvg.

$\backslash$table$[[$SELECT AVG$($Balance$),$AVG$($Balance$),$AVG$($Balance$),$AVG$($Balance$)],[\backslash$table$[[$AS$,$AvgBal,,State,$],[$ SELECT,AVG$($Balance$),]],\backslash$table$[[$AS AvgBal, State,$],[($SELECT AVG$($Balance$)]],\backslash$table$[[$AS AvgBal, State, As$,],[$AVG$($Balance$)$ AS AllAvg,A$]],\backslash$table$[[$AS AvgBal, State,$],[$AVG$($Balance$)$ AS AllAvg$]]],[$FROM tblCustomer$)$ AS$,$FROM tblCustomer$)$ AS$,$FROM tblCustomer,$\backslash$table$[[$FROM tblCustomer$],[$GROUP BY State$]]],[\backslash$table$[[$AllAvg$],[$FROM tblCustomer$]],$Allavg,GROUP BY Sta,HAVING AvgBal$>],[$GROUP BY State,$\backslash$table$[[$FROM tblCustomer$],[$GROUP BY State$]],\backslash$table$[[$AVG$($Balance$)$;$],[$AVI$]],$FROM tblCustomer$)$;$],[$HAVING AVG$($Balance$),\backslash$table$[[$HAVING AVG$($Balance$)],[>$ AllAvg;$]],,],[\backslash$table$[[($SELECT AVG$($Balance$)],[$FROM tblCustomer$)$;$]],,,]]$

SQL$-7.$ List those sales reps who started working for the company before their manager.