Insert the following TinyVideo database to answer all the SQL questions:

CREATE TABLE MEMBERSHIP (MEM_NUM CHAR(5) CONSTRAINT MEM_MEM_NUM_PK PRIMARY KEY, MEM_FNAME VARCHAR(20) NOT NULL, MEM_LNAME VARCHAR(20)NOT NULL, MEM_STREET VARCHAR(30), MEM_CITY VARCHAR(20), MEM_STATE VARCHAR(20), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER(3));

INSERT INTO MEMBERSHIP VALUES('102','TAMI','DAWSON','2632 TAKLI CIRCLE','NORENE','TN','37136',11.11); INSERT INTO MEMBERSHIP VALUES('103','CURT','NULL','4025 CORNELL COURT','FLAGAP','KY','41219',666.11);

UPDATE MEMBERSHIP SET MEM_BALANCE = 6 WHERE MEM_NUM = '103';

SELECT * FROM MEMBERSHIP;

ALTER TABLE MEMBERSHIP MODIFY MEM_STATE CHAR(2);

CREATE TABLE RENTAL (RENT_NUM CHAR(4) CONSTRAINT RENTAL_RENT_NUM_PK PRIMARY KEY, RENT_DATE DATE, MEM_NUM CHAR(5)NOT NULL, CONSTRAINT RENTAL_MEM_NUM_FK FOREIGN KEY (MEM_NUM)REFERENCES MEMBERSHIP);

INSERT INTO RENTAL VALUES ('1001', TO_DATE('01-03-1990','DD-MM-YYYY'),'102');

INSERT INTO RENTAL VALUES ('1002', TO_DATE('01-03-1990','DD-MM-YYYY'),'103');

CREATE TABLE PRICE ( PRICE_CODE CHAR(1) PRIMARY KEY, PRICE_DESC VARCHAR(25) NOT NULL, PRICE_RENTFEE NUMBER(3,1), PRICE_DAILYLATEFEE NUMBER(3,1));

CREATE TABLE MOVIE (MOVIE_NUM CHAR(6) CONSTRAINT MOVIE_NUM_PK PRIMARY KEY, MOVIE_NAME VARCHAR(25) NOT NULL, MOVIE_YEAR CHAR(4), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR(15), PRICE_CODE CHAR(1), CONSTRAINT MOVIE_PRICE_CODE_FK FOREIGN KEY(PRICE_CODE)REFERENCES PRICE);

CREATE TABLE VIDEO (VID_NUM CHAR(6) PRIMARY KEY, VID_INDATE DATE, MOVIE_NUM CHAR(6)NOT NULL, CONSTRAINT VIDEO_MOVIE_NUM_FK FOREIGN KEY(MOVIE_NUM)REFERENCES MOVIE);

CREATE TABLE DETAILRENTAL (RENT_NUM CHAR(4), VID_NUM CHAR(6), DETAIL_FEE NUMBER(3,1), DETAIL_DUEDATE DATE, DETAIL_RETURNDATE DATE, DETAIL_DAILYLATEFEE NUMBER(2), CONSTRAINT DETAIL_RENT_NUM_VID_NUM_PK PRIMARY KEY (RENT_NUM, VID_NUM), CONSTRAINT DETAIL_RENT_NUM_FK FOREIGN KEY(RENT_NUM) REFERENCES RENTAL, CONSTRAINT DETAIL_VIDEO_NUM_FK FOREIGN KEY(VID_NUM) REFERENCES VIDEO);

1. Use your Tiny Viedio database that we created in Lab_03 to answer the following using a subquery: a. Find all movies with a cost less than or equal to the average movies cost b. Write a query to display all the movies that have video copies C. Write a query to display the membership number, first name, last name, and balance of the memberships that have a rental on March-2009. d. Create a New Member table with only using the membership name (Fname and Lname) and membership city. e. List movie title and movie year for movies that have a movie cost that is greater than all individual movie costs for movies with price description "weekly Special