framework/resources/Advanced/mondrian/query77.q

select count(distinct promotion_name) from promotion;