The manager tried to create an aggregate query to calculate the total$610$number of items and average number of items purchased by differentmethods: phone, online, and in person. The results made no sense,and she has asked you to help her figure out why.Open the qryPurchaseMethods query in Design view, make thenecessary correction so that the query displays correct information.Run the query, adjust the column widths so that all data are visible.Save but DO NOT close the query.