sql like statement not recognized in RStudio

Seems like you're having a little trouble producing a reprex. You are much more likely to get help if you post your question and data in any easy to use form. Please take a look at this guide that should help you be able to post your data in a format that we can copy and paste: