For each information request below, formulate a single SQL query to produce the required information.

2) What is the total amount of purchases made in 2015 made by each employee. Include EmployeeID, First and Last names, and total amount. (Use a select subquery in the SELECT clause). Name the column TotalPurchases. When you create it, use both the round and sum functions, i.e. Round (Sum ( ... ) , 2).

3) count the number of unique values of the set of values of purchase date and employee Id from the purchase table. (Use a subquery in FROM) (name column NumbOfEmpPurch)

Sale Itemm PK ?ltemSize PK CustomerID PK |SalelD FirstName PK SalelD PK ProductID Inventory Item PK ItemSize PK ProductID PK lItemSize PK|EmployeeID | manages Purchase Item PK PurchaselD made PK (ManufacturertlD from PK PurchaselD PurchaseDate State Complete, Disjoint) Shipping Wage Phone Fax Wage MaxHours URL