Sharing my guided project and string questions

I am sharing my guided project: Designing and Creating a Database (376).

I could not get RStudio to store my queries as strings. It didn’t like the fact that the query contained empty space. So, I was not able to use the DBI package.

Instead, I used SQL code chunks. Is this an acceptable workaround?

Did anyone have a similar problem? How did you solve it?

Thank you!

7_baseball.pdf (326.0 KB)