| select store.store_country as c0, store.store_state as c1, store.store_city as c2 from store as store, sales_fact_1997 as sales_fact_1997, time_by_day as time_by_day where sales_fact_1997.store_id = store.store_id 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 = 2 and store.store_country in ('Mexico', 'USA') and store.store_state in ('Guerrero', 'Jalisco', 'Veracruz', 'Yucatan', 'Zacatecas', 'CA', 'OR', 'WA') and store.store_city in ('Acapulco', 'Guadalajara', 'Orizaba', 'Merida', 'Camacho', 'Hidalgo', 'Los Angeles', 'San Francisco', 'Portland', 'Salem', 'Bellingham', 'Bremerton', 'Seattle', 'Spokane', 'Tacoma', 'Walla Walla', 'Yakima') and store.store_name in ('Store 1', 'Store 5', 'Store 10', 'Store 8', 'Store 4', 'Store 12', 'Store 18', 'Store 7', 'Store 14', 'Store 11', 'Store 13', 'Store 2', 'Store 3', 'Store 15', 'Store 16', 'Store 17', 'Store 22', 'Store 23') and (store.store_state = 'CA') group by store.store_country, store.store_state, store.store_city having (sum(sales_fact_1997.unit_sales) > 0) order by store.store_country ASC NULLS LAST, store.store_state ASC NULLS LAST, store.store_city ASC NULLS LAST; |