framework/resources/Advanced/mondrian/query6147.q

select promotion.media_type as c0 from promotion as promotion, sales_fact_1997 as sales_fact_1997 where sales_fact_1997.promotion_id = promotion.promotion_id group by promotion.media_type order by promotion.media_type ASC NULLS LAST;