framework/resources/Functional/tpcds/sanity/json/count_promotion.sql

select count(*) from promotion;