SQLGrammarException with native Query in spring boot...

mysql error, springframework.jdbc.BadSqlGrammarException: I got the error msg, couldn't find why...

SQL Grammar Exception-Invalid Character, but query working fine...

Bad SQL grammar exception after deploying in server...