| select store.store_type as c0, promotion.promotion_name as c1 from store as store, sales_fact_1997 as sales_fact_1997, promotion as promotion, customer as customer where sales_fact_1997.store_id = store.store_id and sales_fact_1997.promotion_id = promotion.promotion_id and sales_fact_1997.customer_id = customer.customer_id and customer.state_province = 'WA' and customer.city = 'Anacortes' group by store.store_type, promotion.promotion_name order by store.store_type ASC NULLS LAST, promotion.promotion_name ASC NULLS LAST; |