framework/resources/Advanced/mondrian/query7.q

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