$-$a$.$ "Management is concerned that customers $1007,1012,$ and $1014$ are purchasing beyond the agreed limit$.$ They have requested output showing each purchase transaction by each customer.". Make sure it looks exactly like the example output $($at the back of this assignment$).$ Hint: $504$ rows returned. Required sqI constructs: Table JOINs.

$-$b$.$ "Management would like to know the product names when the retail price is greater than the overall average retail price of all products". Make sure it looks exactly like the example output $($at the back of this assignment$).$ Requirement: Subquery. Hint: $4$ rows returned. Required sql constructs: Subquery

$3.$ Apply the SELECT statements to the MySQL Workbench to accomplish the requests noted.

$4.$ Be sure and meet both explicit requirements as noted in the requirements statement as well as implicit requirements that are provided in the output grid.

$5.$ As noted above, post the SQL $($sql$)$ file that executes the required query. The sql file $($only $1$ file submitted$)$ must be posted in the dropbox by the due date to receive full credit.

$6.$ Output for the requirement $($request$)$ is shown below. Remember, your query should generate the exact same output $($including headers$)$ as shown below.

$\backslash$table$[[,$CustFulliname,CustomerID,TotalsOrdered,,,,$],[*,$Mariya Sergienko,$1007,69\mathrm{.}00,,,,],[,$Mariya Sergienko,$1007,7\mathrm{.}45,,,,],[,$Mariya Sergienko,$1007,72\mathrm{.}00,,,,],[,$Mariya Sergienko,$1007,3600\mathrm{.}00,,,,],[,$Mariya Sergienko,$1007,9603\mathrm{.}00,,,,],[,$Mariya Sergienko,$100,1752-,+,,,],[,$Mariya Sergienko,$100,,,,,]]$