Is there a solution guide for the Intermediate SQL in R mission “Guided Project: Designing and Creating a Database”?
Also, I don’t think that DataQuest has provided enough information to actually accomplish this mission. For instance, I don’t recall learning how to create a new database in SQL (though I do know how to create a new table). Similarly, I don’t know how to use the dbExecute function (though I do know how to use dbFetch, dbGetQuery, dbSendQuery).
Please advise and indicate where the solution guide is. Thanks.