Please write the code for the follownig
1. From Person.Person table, list each person's ID (BusinessEntityID) with "pID" alias, first name (FirstName) with "fname" alias, and last name (LastName) with "lname" alias. Sort the results alphabetically by last name and then by first name.
2. You have been asked to calculate the commission earned by your sales reps for each order they worked. To do this, we will query the Sales.SalesOrderHeader table and list each order number (SalesOrderNumber), sales rep ID (SalesPersonID), order subtotal (SubTotal) (i.e., not including tax and shipping), and a calculated field for 10% commission on each order. Use "CommissionEarned" alias for the calculated field. Exclude records (orders) for which no sales rep is specified.