framework/resources/Advanced/mondrian/query2322.q

select customer.state_province as c0 from customer as customer where (customer.country = 'Canada') and UPPER(customer.state_province) = UPPER('BC') group by customer.state_province order by customer.state_province ASC NULLS LAST;