Write a SELECT statement that uses the analytic functions to get the highest and lowest sales by product within each category. Return these columns: The category_name column from the Categories table
The product_name column from the Products table
A column named total_sales that shows the sum of the sales for each product with sales in the Order_Items table
A column named highest_sales that uses the FIRST_VALUE function to show the name of the product with the highest sales within each category
A column named lowest_sales that uses the LAST_VALUE function to show the name of the product with the lowest sales within each category