Which stores sold the most turkey dinners during the Red Carpet Closeout promotion by day?
Displays all stores with sales for the turkey dinner each day but I only want to display the store with the most sales for each day. So my result should only be displaying 7 results with the dollar amount for each day as well as which store.
SELECT name,description "Description", promotion_name "Promotion Name",
TO_CHAR(SUM(unit_sales), 'L99G999D99MI') AS "Unit Sales", day_of_week "Day"
WHERE product_key = 3
AND promotion_key = 2
GROUP BY day_of_week, name, description, promotion_name
ORDER BY (SUM(unit_sales))DESC, name