$3$ PostgreSQL API in R $(15$ pt$)$

Complete following tasks in R using PostgreSQL API:

$1.$ Make a connection to your local PostgreSQL database.

$2.$ Query the PostgreSQL database via API to get the original bank data. $($The bank data

that you import to PostgreSQL database in Q $1\mathrm{.}1)$ Store the data into a dataframe.

$3.$ Calculate asset growth rate for each quarter and each bank. $($asset growth rate $=($current

quarter value $-$ previous quarter value$)/$ previous quarter value$).$ The result start from

second quarter, since we don$$t have all necessary data for first quarter calculation. Store the

calculation result in a data frame.

$4.$ Export the dataframe of Q $3\mathrm{.}3$ to the PostgreSQL database via API.