select sum(DATA) YS FROM inner_ads_t261_fi_data_sheet_mra_a_m_v
WHERE AND to_char(PERIOD, 'yyyy-MM') between '${startdate}' and '${enddate}'
AND ACCOUNT LIKE '%销量%'
AND TYPE='单台'
and scenario='年度预算'
where后面多了个and,然后between 的话,改成YYYY-MM-DD格式
WHERE to_char(PERIOD, 'YYYY-MM-DD') between '${startdate}' and '${enddate}'