Question: 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
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
Step by Step Solution
3.32 Rating (158 Votes )
There are 3 Steps involved in it
To solve this problem well use SQL to write a query that utilizes analytic functions to find the highest and lowest sales by product within each categ... View full answer
Get step-by-step solutions from verified subject matter experts
