| select time_by_day.the_year as c0, product.product_name as c1, customer.gender as c2, sum(sales_fact_1997.unit_sales) as m0 from time_by_day as time_by_day, sales_fact_1997 as sales_fact_1997, product as product, customer as customer where sales_fact_1997.time_id = time_by_day.time_id and time_by_day.the_year = 1997 and sales_fact_1997.product_id = product.product_id and product.product_name in ('BBB Best Columbian Coffee', 'BBB Best Decaf Coffee', 'BBB Best French Roast Coffee', 'BBB Best Hot Chocolate', 'BBB Best Regular Coffee', 'Booker 1% Milk', 'Booker 2% Milk', 'Booker Buttermilk', 'Booker Chocolate Milk', 'Booker Whole Milk', 'CDR Columbian Coffee', 'CDR Decaf Coffee', 'CDR French Roast Coffee', 'CDR Hot Chocolate', 'CDR Regular Coffee', 'Carlson 1% Milk', 'Carlson 2% Milk', 'Carlson Buttermilk', 'Carlson Chocolate Milk', 'Carlson Whole Milk', 'Club 1% Milk', 'Club 2% Milk', 'Club Buttermilk', 'Club Chocolate Milk', 'Club Whole Milk', 'Even Better 1% Milk', 'Even Better 2% Milk', 'Even Better Buttermilk', 'Even Better Chocolate Milk', 'Even Better Whole Milk', 'Excellent Apple Drink', 'Excellent Apple Juice', 'Excellent Berry Juice', 'Excellent Cola', 'Excellent Cranberry Juice', 'Excellent Cream Soda', 'Excellent Diet Cola', 'Excellent Diet Soda', 'Excellent Mango Drink', 'Excellent Orange Juice', 'Excellent Strawberry Drink', 'Fabulous Apple Drink', 'Fabulous Apple Juice', 'Fabulous Berry Juice', 'Fabulous Cola', 'Fabulous Cranberry Juice', 'Fabulous Cream Soda', 'Fabulous Diet Cola', 'Fabulous Diet Soda', 'Fabulous Mango Drink', 'Fabulous Orange Juice', 'Fabulous Strawberry Drink', 'Good Chablis Wine', 'Good Chardonnay', 'Good Chardonnay Wine', 'Good Imported Beer', 'Good Light Beer', 'Good Light Wine', 'Good Merlot Wine', 'Good White Zinfandel Wine', 'Gorilla 1% Milk', 'Gorilla 2% Milk', 'Gorilla Buttermilk', 'Gorilla Chocolate Milk', 'Gorilla Whole Milk', 'Landslide Columbian Coffee', 'Landslide Decaf Coffee', 'Landslide French Roast Coffee', 'Landslide Hot Chocolate', 'Landslide Regular Coffee', 'Pearl Chablis Wine', 'Pearl Chardonnay', 'Pearl Chardonnay Wine', 'Pearl Imported Beer', 'Pearl Light Beer', 'Pearl Light Wine', 'Pearl Merlot Wine', 'Pearl White Zinfandel Wine', 'Plato Columbian Coffee', 'Plato Decaf Coffee', 'Plato French Roast Coffee', 'Plato Hot Chocolate', 'Plato Regular Coffee', 'Portsmouth Chablis Wine', 'Portsmouth Chardonnay', 'Portsmouth Chardonnay Wine', 'Portsmouth Imported Beer', 'Portsmouth Light Beer', 'Portsmouth Light Wine', 'Portsmouth Merlot Wine', 'Portsmouth White Zinfandel Wine', 'Skinner Apple Drink', 'Skinner Apple Juice', 'Skinner Berry Juice', 'Skinner Cola', 'Skinner Cranberry Juice', 'Skinner Cream Soda', 'Skinner Diet Cola', 'Skinner Diet Soda', 'Skinner Mango Drink', 'Skinner Orange Juice', 'Skinner Strawberry Drink', 'Super Columbian Coffee', 'Super Decaf Coffee', 'Super French Roast Coffee', 'Super Hot Chocolate', 'Super Regular Coffee', 'Token Apple Drink', 'Token Apple Juice', 'Token Berry Juice', 'Token Cola', 'Token Cranberry Juice', 'Token Cream Soda', 'Token Diet Cola', 'Token Diet Soda', 'Token Mango Drink', 'Token Orange Juice', 'Token Strawberry Drink', 'Top Measure Chablis Wine', 'Top Measure Chardonnay', 'Top Measure Chardonnay Wine', 'Top Measure Imported Beer', 'Top Measure Light Beer', 'Top Measure Light Wine', 'Top Measure Merlot Wine', 'Top Measure White Zinfandel Wine', 'Walrus Chablis Wine', 'Walrus Chardonnay', 'Walrus Chardonnay Wine', 'Walrus Imported Beer', 'Walrus Light Beer', 'Walrus Light Wine', 'Walrus Merlot Wine', 'Walrus White Zinfandel Wine', 'Washington Apple Drink', 'Washington Apple Juice', 'Washington Berry Juice', 'Washington Cola', 'Washington Cranberry Juice', 'Washington Cream Soda', 'Washington Diet Cola', 'Washington Diet Soda', 'Washington Mango Drink', 'Washington Orange Juice', 'Washington Strawberry Drink') and sales_fact_1997.customer_id = customer.customer_id and customer.gender = 'F' group by time_by_day.the_year, product.product_name, customer.gender; |