search

jlin47 / mp4

0 stars 0 forks source link

Find out earning for each movie #2

Closed jlin47 closed 6 years ago

jlin47 commented 6 years ago

sql_gross <- " SELECT t.id, t.title, mi.info AS gross_info FROM title t JOIN movie_info mi ON mi.movie_id = t.id; "

gross <- db %>% dbGetQuery(sql_gross) head(gross)