create view as select VID_NO, TITLE, RENT_COUNT from VIDEO ,RENTED,CUSTOMER where VIDEO .VID_NO=RENTED.VID_NO and RENTED.CUST_NO=CUSTOMER.CUST_NO
B.
create view as select VID_NO, TITLE, RENT_COUNT from VIDEO ,RENTED,CUSTOMER
C.
create view view4 as select VID_NO, TITLE, RENT_COUNT from VIDEO ,RENTED,CUSTOMER where VIDEO .VID_NO=RENTED.VID_NO and RENTED.CUST_NO=CUSTOMER.CUST_NO