create view ciew5 as select VID_NO, TITLE, RENT_COUNT from RENTED,VIDEO where RENTED.VID_NO=VIDEO.VID_NO and START_DATE between 2012-1-1 and 2012-1-31 and ETURNED_DATE=null
B.
create view ciew5 as select VID_NO, TITLE, RENT_COUNT from RENTED,VIDEO where RENTED.VID_NO=VIDEO.VID_NO and START_DATE between 2012-1-1 and 2012-1-30 and ETURNED_DATE=null
C.
create view ciew5 as select VID_NO, TITLE, RENT_COUNT from RENTED,VIDEO where RENTED.VID_NO=VIDEO.VID_NO and START_DATE >2012-1-1 and ETURNED_DATE=null