| select store.store_country as c0, store.store_state as c1, store.store_city as c2, store.store_id as c3, store.store_name as c4 from store as store where (store.store_state in ('CA', 'OR')) and ((store.store_city = 'Portland' and store.store_state = 'OR' and store.store_id = 11) or (store.store_city = 'San Francisco' and store.store_state = 'CA' and store.store_id = 14)) group by store.store_country, store.store_state, store.store_city, store.store_id, store.store_name having NOT((sum(store.store_sqft) is null)) order by store.store_country ASC NULLS LAST, store.store_state ASC NULLS LAST, store.store_city ASC NULLS LAST, store.store_id ASC NULLS LAST; |