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

PART a (1) SELECT LNAME AS LAST_NAME FROM BORROWER WHERE CARDNO < 150 ORDER BY LNAME ASC; PART A (2) SELECT LNAME,FNAME,TITLE FROM BORROWER b ,BOOK bb ,LOAN l WHERE b.CARDNO=l.CARDNO AND l.ISBN=bb.ISBN AND DATEOUT BETWEEN '03/JUN/14' AND '08/MAR/18' ORDER BY FNAME ASC; PART A (3) SELECT LNAME,FNAME,COUNT(l.CARDNO) AS TOTAL_NUMBER_OF_LOANS FROM BORROWER b, LOAN l WHERE b.CARDNO=l.CARDNO GROUP BY LNAME , FNAME HAVING LNAME LIKE 'E%' OR LNAME LIKE 'D%' OR LNAME LIKE 'Q%' OR LNAME LIKE 'Z%' SELECT COUNT(l.CARDNO) AS TOTAL_NUMBER_OF_LOANS FROM BORROWER b, LOAN l WHERE b.CARDNO=l.CARDNO AND (LNAME LIKE 'E%' OR LNAME LIKE 'D%' OR LNAME LIKE 'Q%' OR LNAME LIKE 'Z%') Part A (4) SHOW ALL THE BOOK THAT HAS BEEN RELEASED IN IN THE YEAR 1990 , SHOW THE AUTHOR NAME, TITLE OF THE BOOK ISBN ??? SELECT ISBN,PUBLISHERNAME ,TITLE FROM BOOK WHERE YEARPUBLISHED LIKE '1990' ORDER BY TITLE ASC; Part A (5) SELECT DISTINCT LNAME, SUBURB, b.CARDNO FROM BORROWER b ,LOAN l WHERE b.CARDNO=l.CARDNO AND DATEIN < '15/MAR/15' AND l.CARDNO BETWEEN 100 AND 300 AND (b.SUBURB LIKE 'DARWIN' OR b.SUBURB LIKE 'KARAMA') PART A (6) SELECT DISTINCT bn.BRANCHNAME , bn.BRANCHID, COUNT( l.BRANCHID) AS NUMBER_OF_LOANS FROM BRANCH bn LEFT JOIN LOAN l ON l.BRANCHID = bn.BRANCHID GROUP BY bn.BRANCHID, bn.BRANCHNAME ORDER BY bn.BRANCHID ASC; SELECT TITLE FROM BOOK, BORROWER, LOAN WHERE BOOK.ISBN=LOAN.ISBN,BORROWER.CARDNO=LOAN.CARDNO AND BORROWER.SUBURB= 'ALAWA'