MySQL Native Query not working in Spring Data JPA. What could I be doing wrong?
For some reasons my query is running perfectly in MySQL WorkBench but when added to the repository I am getting syntax error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version…