| 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, 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 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', 'Bird Call 200 MG Acetominifen', 'Bird Call Conditioning Shampoo', 'Blue Label Canned Yams', 'Blue Medal Large Eggs', 'Bravo Fancy Canned Clams', 'CDR Strawberry Jam', '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 Avocado Dip', '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 Cauliflower', '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', 'Medalist Spaghetti', 'Modell English Muffins', 'Moms Chicken Hot Dogs', 'Moms Sliced Turkey', 'PigTail Frozen Chicken Breast', 'Plato Creamy Peanut Butter', 'Pleasant Beef Soup', 'Portsmouth Chardonnay', '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 Asparagus', 'Tell Tale Sweet Onion', 'Top Measure Chardonnay', 'Toucan Canned Mixed Fruit', 'Tri-State Fuji Apples', 'Tri-State Party Nuts', 'Walrus Chardonnay Wine') group by store.store_name, time_by_day.the_year, time_by_day.quarter, time_by_day.month_of_year, product.product_name; |