framework/resources/Advanced/mondrian/query412.q

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