| select store.store_sqft as c0, product_class.product_family as c1 from store as store, inventory_fact_1997 as inventory_fact_1997, product as product, product_class as product_class where inventory_fact_1997.store_id = store.store_id and product.product_class_id = product_class.product_class_id and inventory_fact_1997.product_id = product.product_id and store.store_type = 'Supermarket' and (store.store_sqft = 20319) and (product_class.product_family in ('Drink', 'Food', 'Non-Consumable')) group by store.store_sqft, product_class.product_family order by store.store_sqft ASC NULLS LAST, product_class.product_family ASC NULLS LAST; |