Extend the raw data query that retrieves the order date, sales list price (e.g. no discount applied), category name of the product sold, and discount to also include the discount percentage. This information will be used to generate the total markdowns in each category and analyze how they are changing.
The result should look like this:
The expert performance time for this task is 30 seconds. The performance test assumes you are starting from the query created earlier.