Create the following select queries:

Add a new column to the table called Commission.

Create update queries to calculate the commission. If the Amount Sold is 25,000 or less give a 5% Commission. However, if the Amount Sold is over 25,000 for the first 25,000 it is 5% and for the amount over 25,000, it is 10%.

Each individual will receive a base salary of $500 which is calculated in the Total Salary.

Add one more column called TotalSalary. Create an update an update query calculating TotalSalary which is based on the Commission and the base salary.

Please show the formula put in the update and criteria.