Create $3$ tables, insert values $(1-$point$).$

salesperson

$\backslash$table$[[$id$,$name,salary,commission.percent,Date$],[1,$John,$100000,6,4/1/20006],[2,$Amy,$120000,5,5/1/2010],[3,$Mark,$65000,12,12/25/2008],[4,$Pam,$25000,25,1/1/2005],[5,$Alex,$50000,10,2/3/2007]]$

$\backslash$table$[[$customer typelocation,$],[$cust type id$,$name,city$],[1,$Red,Boston$],[2,$Orange,New York$],[3,$Yellow,Boston$],[4,$Green,Austin$]]$

$\backslash$table$[[$order$,,],[$id$,$date,cust type id$,$saldes id$,$amount$],[1,\frac{1}{1}\frac{?}{2014},3,4,100000],[2,\frac{2}{1}\frac{?}{2014},4,5,5000],[3,\frac{3}{1}\frac{?}{2014},1,1,50000],[4,\frac{4}{1}\frac{?}{2014},1,4,25000]]$

Answer the queries based on the data above $(1-$point each$)$

Write a query that will calculate the total commission $($order amount $*$ commission percent$/100)$ by salesperson.

Write a query that lists all orders where commission was greater than $10\%$

Write a query that lists the city along with full order details

Write a query that lists the name of salesperson whose salary is greater than $50000$ and commission greater or equal to $10\%$

Write the names of salesperson who have made orders in Boston.