Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Important fields that will be needed ( to save space I used abbreviations that should NOT be used in actual programming ) : tblCustomer: CustomerNumber
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 Based on the above table, identify the customer Name State who has a balance at least hi the average balance in their own state.
SELECT Name, State FROM tblCustomer Cust WHERE balance
SELECT AVGBalance FROM tblCustomer
WHERE State Cust.State GROUP BY State;
SELECT Name, State FROM tblCustomer C
WHERE balance
SELECT AVGBalance FROM Cust
WHERE State Cust.State GROUP BY State;
SELECT Name, State FROM tblCustomer WHERE balance
SELECT AVGBalance FROM
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started