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

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 colnmission was greater than $\backslash (10\backslash \%\backslash )$

$-$ 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\backslash \%$

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