An organization wishes to keep track of their orders along with the employee who processed the orders. The data they need includes the employee number, their start date, their salary and the commission percentage (the maximum commission is 40%) and each order can only have one employee earn a commission. They also need to keep track of the order number, quantity, and order date.

B3) Show the SQL Server code to:

Update Employee number 1001 to change their salary to $50,000