R RStudio File Edit Code View Plots Session Build Debug Profile Tools Help chinook (3).rx 日 Source on Save 3 library(DBI) Go to file/function ▾ Addins ▾ Run Environment History Connections Tutorial Source Import Dataset 165 MIB ▼ R▾ Global Environment ▾ a Project: (None) List ▾ 4 library(RSQLite) 5 drv <- dbDriver ("SQLite") 6 7 con <- dbconnect (drv, dbname="chinook.db") ##be sure chinook.db is in the R workir dbListTables (con) Environment is empty 8 query

Advanced Engineering Mathematics
10th Edition
ISBN:9780470458365
Author:Erwin Kreyszig
Publisher:Erwin Kreyszig
Chapter2: Second-order Linear Odes
Section: Chapter Questions
Problem 1RQ
icon
Related questions
Question

Please show me how this would look in the R studio, I can not get chinook.db to work.  Download the chinook database. This is an example assignment to teach us and prepare us for the big test. 

Place the “chinook.db” file in your R Studio working directory

library(DBI)

library(RSQLite)

drv <- dbDriver("SQLite")

con <- dbConnect(drv, dbname="chinook.db")

dbListTables(con) to test connection

You should be able to see this line in your console

 "Album"   "Artist"   "Customer"  "Employee"  "Genre"     

   "Invoice"    "InvoiceLine"  "MediaType"   

 "Playlist"      "PlaylistTrack" "Track"    

R RStudio
File Edit Code View Plots Session Build Debug Profile Tools Help
chinook (3).rx
日
Source on Save
3 library(DBI)
Go to file/function
▾ Addins ▾
Run
Environment
History Connections
Tutorial
Source
Import Dataset
165 MIB ▼
R▾
Global Environment ▾
a
Project: (None)
List ▾
4
library(RSQLite)
5
drv <- dbDriver ("SQLite")
6
7
con <- dbconnect (drv, dbname="chinook.db") ##be sure chinook.db is in the R workir
dbListTables (con)
Environment is empty
8
query<dbGetQuery(con, "select * from Album;")
9
query
10
query<dbGetQuery(con, "select avg (Milliseconds) from Track;")
11
query
12
13
14
query<dbGetQuery(con, "select artistid from Artist where Name = 'Queen' ")
15
query <- dbGetQuery(con, "select customerid, sum(total) from Invoice group by cust
query
query
16
query<dbGetQuery(con, "select composer from Track order by Milliseconds; ")
17
query
Files Plots Packages
New Folder New Blank File ▾
Help
Viewer
Presentation
* Delete
Rename
More ▾
18
query <- dbGetQuery(con, "select Name, Title from Track join Album using (AlbumId)
Home
19
query
Name
Size
Modified
20
1:1
(Top Level) +
Console
Terminal x
Background Jobs x
RR 4.4.1 ~
R Script
Chapter 8 Quiz_ MG343ZA Supervisory Management.pdf
Chapter 9 Quiz MG343ZA Supervisory Management.pdf
CheapOair transript.docx
127.6 KB
Mar 27, 2024, 8:02 PM
124.3 KB
Apr 3, 2024, 2:36 PM
chinook.db
116.4 KB
OB
May 13, 2024, 7:51 PM
Sep 9, 2024, 4:06 PM
Command & Conquer 3 Kane's Wrath
DOOOO
BBBBBB
Command and Conquer 3 Kanes Wrath
Command and Conquer 3 Tiberium Wars
Command and Conquer Generals Data
Command and Conquer Generals Zero Hour Data
Copies of Passports and IDs
CopilotAnswers-20240617-190422.xlsx
CopilotAnswers-20240624-144823.xlsx
Current Enrollment Spring 2024.pdf
Custom Office Templates
7 KB
Jun 17, 2024, 7:05 PM
6.8 KB
493.3 KB
Jun 24, 2024, 2:48 PM
Dec 26, 2023, 11:10 AM
Transcribed Image Text:R RStudio File Edit Code View Plots Session Build Debug Profile Tools Help chinook (3).rx 日 Source on Save 3 library(DBI) Go to file/function ▾ Addins ▾ Run Environment History Connections Tutorial Source Import Dataset 165 MIB ▼ R▾ Global Environment ▾ a Project: (None) List ▾ 4 library(RSQLite) 5 drv <- dbDriver ("SQLite") 6 7 con <- dbconnect (drv, dbname="chinook.db") ##be sure chinook.db is in the R workir dbListTables (con) Environment is empty 8 query<dbGetQuery(con, "select * from Album;") 9 query 10 query<dbGetQuery(con, "select avg (Milliseconds) from Track;") 11 query 12 13 14 query<dbGetQuery(con, "select artistid from Artist where Name = 'Queen' ") 15 query <- dbGetQuery(con, "select customerid, sum(total) from Invoice group by cust query query 16 query<dbGetQuery(con, "select composer from Track order by Milliseconds; ") 17 query Files Plots Packages New Folder New Blank File ▾ Help Viewer Presentation * Delete Rename More ▾ 18 query <- dbGetQuery(con, "select Name, Title from Track join Album using (AlbumId) Home 19 query Name Size Modified 20 1:1 (Top Level) + Console Terminal x Background Jobs x RR 4.4.1 ~ R Script Chapter 8 Quiz_ MG343ZA Supervisory Management.pdf Chapter 9 Quiz MG343ZA Supervisory Management.pdf CheapOair transript.docx 127.6 KB Mar 27, 2024, 8:02 PM 124.3 KB Apr 3, 2024, 2:36 PM chinook.db 116.4 KB OB May 13, 2024, 7:51 PM Sep 9, 2024, 4:06 PM Command & Conquer 3 Kane's Wrath DOOOO BBBBBB Command and Conquer 3 Kanes Wrath Command and Conquer 3 Tiberium Wars Command and Conquer Generals Data Command and Conquer Generals Zero Hour Data Copies of Passports and IDs CopilotAnswers-20240617-190422.xlsx CopilotAnswers-20240624-144823.xlsx Current Enrollment Spring 2024.pdf Custom Office Templates 7 KB Jun 17, 2024, 7:05 PM 6.8 KB 493.3 KB Jun 24, 2024, 2:48 PM Dec 26, 2023, 11:10 AM
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Advanced Engineering Mathematics
Advanced Engineering Mathematics
Advanced Math
ISBN:
9780470458365
Author:
Erwin Kreyszig
Publisher:
Wiley, John & Sons, Incorporated
Numerical Methods for Engineers
Numerical Methods for Engineers
Advanced Math
ISBN:
9780073397924
Author:
Steven C. Chapra Dr., Raymond P. Canale
Publisher:
McGraw-Hill Education
Introductory Mathematics for Engineering Applicat…
Introductory Mathematics for Engineering Applicat…
Advanced Math
ISBN:
9781118141809
Author:
Nathan Klingbeil
Publisher:
WILEY
Mathematics For Machine Technology
Mathematics For Machine Technology
Advanced Math
ISBN:
9781337798310
Author:
Peterson, John.
Publisher:
Cengage Learning,
Basic Technical Mathematics
Basic Technical Mathematics
Advanced Math
ISBN:
9780134437705
Author:
Washington
Publisher:
PEARSON
Topology
Topology
Advanced Math
ISBN:
9780134689517
Author:
Munkres, James R.
Publisher:
Pearson,