Caught exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 17
The SQL being executed was: SELECT
sum(manpower) as manpower,
sum(exits) as exits,
-- ifnull(round((sum(exits)/sum(manpower))*100,2),0) as attrition
IFNULL(ROUND(((SUM(exits) / SUM(manpower)) * 100)*9, 2), 0) AS attrition
FROM
user_attrition_dashboard a,
dealership_master c,
audi_neev_designation b
WHERE
c.dealership_id = a.dealer_id
and b.id=a.neev_designation_id
and year='2024'
and month<='9'
-- and a.department=2
and b.dept=2
&& c.dealership_id in ()