blob: 7f0d6399f6c3328b764b204ee7f1e251dc3f889e [file] [log] [blame]
select store.store_city as c0, store.store_postal_code as c1 from store as store where (store.store_state = 'WA') and UPPER(store.store_city) = UPPER('Bremerton') group by store.store_city, store.store_postal_code order by store.store_city ASC NULLS LAST;