try to convert from ms sql to mysql got error

Question

select count(1) 
FROM sms_mdm_detail st, schools s, report_blockwise b 
where st.sms_code='ATTD' AND st.date BETWEEN @start_date AND @end_date and 
      st.school_code=s.school_code and
      s.district_code=b.District_code and s.block_code=b.Block_code 
having (count(DISTINCT CAST(varchar(12),date,105))/@work_days)*100>=51)

Answer 1

等待大神答复