Write the SQL queries for the tables created in Part a and Part b$.$

i$.$ Write a query to list all the videos where the cost of the video is between $50$ and $75.$

ii$.$ Write a query to list the details of all customers last names that begin with the

letters $$Kne$$

iii. Write a query to list the customer id$,$ first name, last name, state and total number

of videos borrowed by the customer.

iv$.$ Write a query to list each customer first name, last name, the rented video name

and due date.

v$.$ Write a query to create a view $$BorrowDetails$$ for the query used in previous

question and also display the number of videos each customer has from the newly

created view