provide the code for R studio (sql)

Create a new dataframe named cc8 to store the results of the SQL query you build for this question. (Note: your environment file must contain cc8 to get full credit on this task.) Which movie with the actor Jamie Foxx has the longest run time? a) Django Unchained b) The Amazing Spider-Man 2 c) Project Power d) Booty Call e) Robin Hood f) Annie Hide hint for Question 13 Run time is the same as duration Use the ORDER BY clause to organize the movies by running time (see workshop task 4d for a similar but not exact example) You can also use the MAX function to identify the single longest running time movie (see workshop task 6a for a similar but not exact example) a