| select store.store_name as c0, time_by_day.the_year as c1, time_by_day.quarter as c2, time_by_day.month_of_year as c3, product.product_name as c4, customer.customer_id as c5, sum(sales_fact_1997.store_sales) as m0 from store as store, sales_fact_1997 as sales_fact_1997, time_by_day as time_by_day, product as product, customer as customer where sales_fact_1997.store_id = store.store_id and store.store_name = 'Store 14' and sales_fact_1997.time_id = time_by_day.time_id and time_by_day.the_year = 1997 and time_by_day.quarter = 'Q1' and time_by_day.month_of_year = 1 and sales_fact_1997.product_id = product.product_id and product.product_name in ('American Low Fat Cole Slaw', 'BBB Best Apple Jam', 'Best Choice Dried Apples', 'Best Choice Low Fat Chips', 'Better Creamed Corn', 'Better Fancy Canned Sardines', 'Bravo Fancy Canned Clams', 'Carrington Turkey TV Dinner', 'Club Cheese Spread', 'Club Sharp Cheddar Cheese', 'Cormorant Paper Plates', 'Cormorant Screw Driver', 'Cutting Edge Pimento Loaf', 'Denny Toilet Paper', 'Fast No Salt Popcorn', 'Faux Products 200 MG Acetominifen', 'Fort West BBQ Potato Chips', 'Fort West Corn Chips', 'Fort West Salted Pretzels', 'Gerolli Seasoned Hamburger', 'Giant Large Brown Eggs', 'Golden Frozen Chicken Breast', 'Hermanos Cauliflower', 'Hermanos Firm Tofu', 'Hermanos Macintosh Apples', 'Hermanos Potatos', 'High Top Cantelope', 'High Top Honey Dew', 'High Top Lemons', 'High Top Mushrooms', 'Horatio Cheese Dip', 'Horatio Low Fat Cookies', 'Horatio Mini Donuts', 'Johnson Grits', 'Just Right Canned Peas', 'Kiwi Scallops', 'Landslide Creamy Peanut Butter', 'Modell English Muffins', 'Moms Chicken Hot Dogs', 'Moms Sliced Turkey', 'PigTail Frozen Chicken Breast', 'Plato Creamy Peanut Butter', 'Pleasant Beef Soup', 'Red Spade Sliced Chicken', 'Red Wing Scissors', 'Sphinx Bagels', 'Steady Childrens Cold Remedy', 'Steady Extra Moisture Shampoo', 'Sunset Paper Plates', 'Super Strawberry Jam', 'Tell Tale Sweet Onion', 'Top Measure Chardonnay', 'Toucan Canned Mixed Fruit', 'Tri-State Party Nuts', 'Walrus Chardonnay Wine') and sales_fact_1997.customer_id = customer.customer_id and customer.customer_id in (5, 508, 1924, 2274, 3861, 3962, 4293, 4387, 5005, 6131, 6613, 7314, 7495, 7962, 8401, 8648, 8762, 8830, 10197) group by store.store_name, time_by_day.the_year, time_by_day.quarter, time_by_day.month_of_year, product.product_name, customer.customer_id; |