Add 0.5 percent to the commission rate of agents who have sold more than $20,000 in engagements. — Translation: Update the agents table by increasing the commission rate .5% for the agents who have sold more than $20,000 in engagements
— Add 0.5 percent to the commission rate of agents who have sold more than $20,000 in engagements.
— Translation: Update the agents table by increasing the commission rate .5% for the agents who have sold more than $20,000 in engagements
— Clean Up: Update agents table by setting CommissionRate = CommissionRate * 1.5 where the AgentID has a sum of more than $20,0000 in ContractPrice
— from the engagements table
SQL:
Update agents
Set agents.CommissionRate = agents.CommissionRate * 1.005
Where Agents.agentID = (select AgentID From
engagements group by agentID
having sum(engagements.ContractPrice) >= 20000)
i keep getting an error stating that the subquery is pulling back more than one row. what am i doing wrong with this translation?
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"
