Query Databases and Data frames in R with SQL

Query Databases and Data frames in R with SQLThe link is for database files：https://drive.google.com/file/d/1m7i0qF0HPVyuwx5Wk…ResourcesFirst Steps in RLecture Notes on R and ExamplesQuerying Data Frames in R with SQL using sqldfInstructionsCreate an R Notebook and do the following tasks in separate code chunks:1. (20 pts) In the R Notebook, connect to the SQLite MediaDB.db(https://northeastern.instructure.com/courses/80530/files/9239221/download?download_frd=1)database and then load, using SQL SELECT, the “invoice_items” table into a data frame called rs.Add a new column to rs for the extended price called ExtPrice that is Quantity times Price. UsingR, what is the average extended price (rounded to 2 decimals)? Do not use {sql} chunks for this.2. (30 pts) Using sqldf, write a SQL query against the data frame rs from the question above thatfinds the total amount for each invoice (i.e., the sum of the extended prices for the invoice_itemsin each invoice) and the number of items in the invoice. So, the result set contains rows that eachhave the invoice ID, the total, and the number of items.3. (30 pts) Using R and the result from the prior question, create a scatter plot of the total number ofitems in an invoice (x axis) versus the total (y axis). Add proper axis labels.4. (20 pts) Write and execute a SQL UPDATE statement that applies a 10% discount to the totalamount for each invoice if it has more than 5 items and stores that discounted amount in a newcolumn called DiscPrice. Using a separate {r} chunk show that the query executed properly by2021/6/17 [90 min] DO: Assignment 5 / Query Databases and Dataframes in R with SQL2/2displaying a part of the table. If you cannot use sqldf, then apply to the database directly instead;either are acceptable as long as you use a SQL UPDATE.Requirements: no | R