How do I get data stored into an SQLite database in a form that I can run an OLS on it in rstudio. I want the code to look like this:

library

(DBI)

library

(RSQLite)

con <- dbConnect(RSQLite::SQLite(),

"~/desktop/examData.db"

)

dbListTables(con)

dbListFields(con,

"answer"

)

dbListFields(con,

"questions"

)

dbListFields(con,

"student_details"

)

rs <- dbSendQuery(con,

"SELECT * FROM answer"

)

rows <- dbFetch(rs)

object.size(rows)