framework/resources/Advanced/mondrian/query43.q

select promotion.media_type as c0 from promotion as promotion where UPPER(promotion.media_type) = UPPER('Time.Time By Week55') group by promotion.media_type order by promotion.media_type ASC NULLS LAST;