Please answer these three Access queries for the Shirtorders database and then upload the database through Canvas when you are finished. Query1: (15pts) Customer 3 comes in to return a defective item. Its product identifier is ProductID=7. The customer thinks he/she purchased it in either November or December of 2015. Please provide a list of all OrderlDs the customer placed in November and December of 2015 for this product and the quantity purchased for each order, along with the last name of the employee who took the order Query2 (15pts): For each supplier, we want to know the types of shirts (ProductIDs) we purchased from them, and the number of each we sold. Query3 (20pts): For each employee, we would like to calculate how much revenue they earned by selling each gender of shirt (Male, Female, and Both) during 2015, and compare it with the costs of purchasing the shirts (UnitCost). Reminder: The Access function Month) prints out the number of the month(1,2,3...12) for any date, and Year) prints out the year of that date. Please download only one version of the Access exam hile, depending on the first letter of your last name: For A F. download: Shictorders Midl Questions Sn21 Viac db For G-L. download: Shirtorders Midt Questions S2 V2.acadh Please answer these three Access queries for the Shirtorders database and then upload the database through Canvas when you are finished. Query1: (15pts) Customer 3 comes in to return a defective item. Its product identifier is ProductID=7. The customer thinks he/she purchased it in either November or December of 2015. Please provide a list of all OrderlDs the customer placed in November and December of 2015 for this product and the quantity purchased for each order, along with the last name of the employee who took the order Query2 (15pts): For each supplier, we want to know the types of shirts (ProductIDs) we purchased from them, and the number of each we sold. Query3 (20pts): For each employee, we would like to calculate how much revenue they earned by selling each gender of shirt (Male, Female, and Both) during 2015, and compare it with the costs of purchasing the shirts (UnitCost). Reminder: The Access function Month) prints out the number of the month(1,2,3...12) for any date, and Year) prints out the year of that date. Please download only one version of the Access exam hile, depending on the first letter of your last name: For A F. download: Shictorders Midl Questions Sn21 Viac db For G-L. download: Shirtorders Midt Questions S2 V2.acadh