Is it correct sql query inside jpa repository interface method annotation?

I have a library with books, readers and reservations. I need to select all book reservations by book title. Am I doing it correctly:
A book may have many reservations as well as users which are readers who borrow it. Should I refer to the string title using ?1 when using native sql query?
In jpql it would be the case. And is my query correct for my task?
image.png
Was this page helpful?