framework/resources/Advanced/mondrian/query3.q

select store.store_state as c0 from store as store where (store.store_country = 'USA') and UPPER(store.store_state) = UPPER('CA') group by store.store_state order by store.store_state ASC NULLS LAST;