เขียนคำลั่ง SQL QUERY รันไม่ได้ครับ Error ครับ

SELECT  t.id,t.types_id,c.clinic_name,c.group_clinic,t.total,t.total_date
FROM   temp_data_opd  t  
INNER JOIN   clinic  c  ON  t.clinic_id=c.id  
WHERE (t.total_date) BETWEEN MONTH(t.total_date)=10 AND MONTH(t.total_date)=12
AND YEAR(t.total_date)=2016

SELECT  t.id,t.types_id,c.clinic_name,c.group_clinic,t.total,t.total_date
FROM   temp_data_opd  t  
INNER JOIN   clinic  c  ON  t.clinic_id=c.id  
WHERE  ((MONTH(t.total_date)>=10) AND (MONTH(t.total_date))>=10))
AND YEAR(t.total_date)=2016