GGive answer of c part from $1$ to $5$ which is in the second picture. The tables were created in the part a and b in the above image. No need to answer these. Just answer part c$.$ Activity $2$: SQL Queries $($Case Study$)$: Video Rental $($VR$)$ is an emerging venture specializing in video rentals. They are seeking to establish a database to manage video information, customer records, rental transaction details, and rental fee calculations. VR has reached out to you to design a comprehensive database that encompasses the following tables:ITDA$1001$ Database Fundamentals c$.$ Write the SQL queries for the tables created in Part a and Part b$.$ i$.$ Create a query to display all videos with a cost falling between $19$ and $99.$ ii$.$ Formulate a query to reveal the information of customers whose last names start with $\text{'}$Ro$.\text{'}$ iii. Develop a query to list customer IDs, first names, last names, states, and the total number of videos borrowed by each customer. iv$.$ Construct a query to showcase each customer's first name, last name, the rented video's name, and the due date. v$.$ Draft a query to generate a view named "BorrowDetails" based on the previous question's query and additionally display the count of videos each customer possesses from this newly created view. Activity $3$: Database Administration Examine the database established during Activity $2$ and deliberate on the various forms of$(18)$ Jo $\backslash$times $|$ M Inbox TateSp Whats $(18)$ SI ITDA$10$ Create Post a ITDA$10$ Exami x x $($CATKir x x x x File $|$ C:$/$Users$/$Nikhil$/$Downloads$/$ITDA$1001-$Assignment$\%202.$pdf M Gmail Maps $$ ITDA$1001-$Assignment $2.$pdf $5/9106\%700343273\mathrm{.}501/04/202129/03/2021$

$700366371001/04/202129/03/2021$

$70036634601/04/202101/04/2021$

$70044326501/04/202101/04/2021$

$700443281201/04/2021$

$700554333\mathrm{.}507/05/2021$

$700466351001/04/202101/04/2021$

$3$ Table $4$ Charge ChargeCode Description RentFee LateFee

$1$ Standard $52$

$2$ New $104$

$3$ Discount $20\mathrm{.}5$

$45$ Type here to search $4700343273\mathrm{.}501/04/202129/03/2021$

$700366371001/04/202129/03/2021$

$70036634601/04/202101/04/2021$

$70044326501/04/202101/04/2021$

$700443281201/04/2021$

$700554333\mathrm{.}507/05/2021$

$700466351001/04/202101/04/2021$

Table $4$ Charge Table $5$ VideoCopy VideoCopy$\_$Num VideoCopy$\_$ArrivalDate SSNV

$432510/01/20191337627909$

$432610/01/20191337627909$

$432710/01/20191337627909$

$432812/02/20190241258766$

$432912/02/20190241258766$

$543216/04/20191292166622$

$543316/04/20191292166622$

$543416/04/20191292166622$

Charge ChargeCode $($PK$),$ Description, RentFee, DailyLateFee a$.$ Write SQL queries for table creation based on the provided information. Select suitable data types for each attribute and identify appropriate primary and foreign keys as needed. b$.$ Formulate an Insert query to input the provided sample data into the tables established in Part a$.$ The sample data is available in the following tables.