SQL ! SQL - DATABASE DATABASE JUST CHANGE THE CODES A BIT

PART C QUESTION 1 SELECT * FROM ( SELECT BOOK.ISBN , BOOK.TITLE FROM BOOK , LOAN WHERE BOOK.ISBN = LOAN.ISBN GROUP BY BOOK.TITLE,BOOK.ISBN ORDER BY COUNT(LOAN.ISBN) DESC ) WHERE ROWNUM <=5 PART C QUESTION 2 SELECT BRANCHNAME FROM BRANCH b WHERE b.BRANCHID IN (SELECT DISTINCT b.BRANCHID FROM BRANCH b LEFT JOIN LOAN l ON b.BRANCHID=l.BRANCHID WHERE l.BRANCHID IS NULL) ORDER BY BRANCHNAME ASC PART C QUESTION 3 SELECT BRANCH.BRANCHID , BRANCH.BRANCHNAME , MAX(DATEIN - DATEOUT) FROM BRANCH LEFT JOIN LOAN ON LOAN.BRANCHID = BRANCH.BRANCHID GROUP BY BRANCH.BRANCHNAME, BRANCH.BRANCHID ORDER BY BRANCH.BRANCHID ASC PART C QUESTION 4 METHOD 1 SELECT b.LNAME, b.FNAME FROM BORROWER b,LOAN l WHERE b.CARDNO = l.CARDNO AND (l.DATEIN = '16- DEC-10' OR l.DATEIN = '08-MAY-12') METHOD 2 SELECT b.LNAME, b.FNAME FROM BORROWER b,LOAN l WHERE b.CARDNO = l.CARDNO AND l.DATEIN IN ('16-DEC-10','08-MAY-12') QUESTION NUMBER 5 DELETE FROM CDUINVOICE WHERE ROWID NOT IN( SELECT MIN(ROWID) FROM CDUINVOICE GROUP BY INVOICE_NO, ID, INVOICE__DATE) SELECT * FROM CDUINVOICE