framework/resources/Advanced/mondrian/query6670.q

select promotion.promotion_name as c0 from promotion as promotion where UPPER(promotion.promotion_name) = UPPER('Cash Register Lottery') group by promotion.promotion_name order by promotion.promotion_name ASC NULLS LAST;