framework/resources/Advanced/mondrian/query6.q

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