Instruction: Describe how to connect to and perform operations on a SQL database using R.
Context: This question is designed to test the candidate's ability to interface R with SQL databases, including data extraction, manipulation, and storage.
hard