blob: c24def572f478acf6c4eebc50958d803417344df [file] [log] [blame]
select store.store_state as c0 from employee as employee, store as store where employee.store_id = store.store_id and (store.store_country = 'USA') and UPPER(store.store_state) = UPPER('CA') group by store.store_state order by store.store_state ASC NULLS LAST;