I have written a custom MySQL query and it works perfectly when executed using MySQL or any other MySQL databse application/editor.

However, when I use the same query to import data into Zoho, I get the below parsing error 

My SQL query is: SELECT YEAR(r.created_at) AS 'Year', MONTHNAME(r.created_at) AS 'Month', count(distinct r.name) AS 'Partners On-boarded' FROM roles r GROUP BY YEAR(r.created_at) DESC, MONTHNAME(r.created_at) ASC;

Can someone tell me whats the issue with the query in Zoho?

Thanks,

Manish