(Based on the North-wind database) Create an appropriate query that allows you to see the total revenue broken down by any of product name, product category, month-year of order date, or customer. Here revenue is defined as Unit-Price*Quantity*(1-Discount), where these fields all come from the Order Details table. You can do this in either of two ways. First, you can return all of the data as a table, then use an Excel formula to calculate revenue for each row, and finally use a pivot table to get the desired results. Second, you can create a calculated field Revenue in Microsoft Query and return the results as a pivot table. (The latter is actually preferable because a pivot table takes up less room in Excel. Imagine if there were millions of rows in the Order Details table. They wouldn't fit in Excel if you tried to bring them in as a table, but this isn't a problem with a pivot table.)