Question 1 Question 2 Question 3 Question 4 Question 5 Question 6 Question 7 Question 8 Question 9

ANSWERS Corrections
1. SELECT B.TITLE AS TITLE, SUM (O.QUANTITY) AS NUMBER FROM BOOKS B INNER JOIN ORDERITEMS O ON O.ISBN=B.ISBN GROUP BY B.ISBN ORDER BY NUMBER DESC, TITLE ASC;
2. SELECT O.ORDERDATE,COUNT(OI.QUANTITY) AS NUMBER,SUM(B.COST) AS RETAIL FROM ORDERS O INNER JOIN ORDERITEMS OI ON OI.ORDERID=O.ORDERID INNER JOIN BOOKS B ON B.ISBN=OI.ISBN GROUP BY O.ORDERDATE,OI.ISBN ORDER BY ORDERDATE ASC;
3. SELECTO.ORDERID,O.PERSONID,O.ORDERDATE,O.SHIPDATE,O.SHIPSTREET,O.SHIPCITY,O.SHIPSTATE,O.SHIPPOSTCODE FROM ORDERS O...