I need help with this assignment please

Question

Please insert your SQL statement and add a result table/output as a screenshot.

1. List names of films with types
2. List the customer who rented movies most frequently
3. List all information about customers
4. List all information about films
5. List films that is horror or action
6. List customers who live in London
7. List movies that were rented after 11-01-2014
8. List films that is horror and price is greater than $5 
9. Add 3 more movies that are comedy and price with $9 (you can add any movie names)
10. Add 3 more customers who live in Towson (you can add any names)
11. Update the price of all action movies to $10.00
12.  Add 3 more movie rental records.
13.  Delete a record of the customer who lives in Columbia

using this code

Create table film (

FID varchar2(4),

FNAME VARCHAR2(12) NOT NULL,

PRICE NUMBER (5,2) NOT NULL,

TYPE VARCHAR2(10),

CONSTRAINT f_price CHECK (PRICE >0 and PRICE <19.99),

CONSTRAINT tYPE_cHECK CHECK(TYPE IN ('ACTION','HORROR', 'COMEDY', 'DRAMA')),

CONSTRAINT F_PK PRIMARY KEY(FID));

Create table customer(

CID varchar2(4),

CNAME varchar2(12) not null,

CITY Varchar2 (10) not null,

Constraint C_PK primary key (CID));

CREATE TABLE RENT(

CID VARCHAR2(4),

FID VARCHAR2(2),

RDATE DATE,

CONSTRAINT R_PK PRIMARY KEY(CID,FID),

CONSTRAINT R_FK1 FOREIGN KEY(CID) REFERENCES CUSTOMER(CID),

CONSTRAINT R_FK2 FOREIGN KEY(FID) REFERENCES FILM(FID));

INSERT INTO CUSTOMER (CID, CNAME, CITY) VALUES ('C1', 'Smith', 'London');

INSERT INTO CUSTOMER (CID, CNAME, CITY) VALUES ('C2', 'Jones', 'Paris');

INSERT INTO CUSTOMER (CID, CNAME, CITY) VALUES ('C3', 'Blake', 'Paris');

INSERT INTO CUSTOMER (CID, CNAME, CITY) VALUES ('C4', 'Clark', 'London');

INSERT INTO CUSTOMER (CID, CNAME, CITY) VALUES ('C5', 'Adams', 'Athens');

INSERT INTO FILM (FID, FNAME, PRICE, TYPE) VALUES ('F1', 'Jurassic Park', '2.99', 'ACTION');

INSERT INTO FILM (FID, FNAME, PRICE, TYPE) VALUES ('F2', 'The Others', '3.55', 'HORROR');

INSERT INTO FILM (FID, FNAME, PRICE, TYPE) VALUES ('F3', 'Senseless', '5.99', 'COMEDY');

INSERT INTO FILM (FID, FNAME, PRICE, TYPE) VALUES ('F4', 'Dragon Heart', '6.00', 'DRAMA');

INSERT INTO FILM (FID, FNAME, PRICE, TYPE) VALUES ('F5', '007', '5.00', 'ACTION');

INSERT INTO FILM (FID, FNAME, PRICE, TYPE) VALUES ('F6', 'American Sweetheart', '0.59', 'COMEDY');

INSERT INTO RENT (CID, FID, RDATE) VALUES ('C1', 'F1', '2014-01-01');

INSERT INTO RENT (CID, FID, RDATE) VALUES ('C1', 'F2', '2014-10-02');

INSERT INTO RENT (CID, FID, RDATE) VALUES ('C1', 'F3', '2014-09-04');

INSERT INTO RENT (CID, FID, RDATE) VALUES ('C2', 'F2', '2014-04-01');

INSERT INTO RENT (CID, FID, RDATE) VALUES ('C4', 'F2', '2014-01-01');

Answer 1

Hello Sasha,

I would like to suggest that before seeking a solution, please try to work on the problem yourself and share the solution you have come up with. This way, we can discuss and address any specific issues or challenges that you faced while attempting to solve the problem. I am happy to provide assistance and guidance on specific problem areas to help you find a solution.

Thank you.

Chandra