Please review chapters 9, 11. of the book Oracle 12c SQL by Joan Casteel

THE TEST WILL BE BASED ON USING JOINS AND GROUP FUNCTIONS, AS WELL AS WHERE, AND HAVING CONDITIONS. MAKE SURE YOU KNOW HOW TO USE GROUP BY AND JOIN

FOR PRACTICE PLEASE DO THE FOLLOWING QUESTIONS:

1) MAKE A LIST OF CUSTOMERS WITH THE LIST OF ORDER# AND THE AMOUNT OF DOLLARS THAT THEY PAID FOR EACH OF THEIR ORDERS, SORT BY CUSTOMER LAST NAME.

2) MAKE A LIST OF CUSTOMERS WITH THE TOTAL AMOUNT OF DOLLARS THAT THEY PAID FOR ALL THEIR ORDERS COMBINED (FOR EACH CUSTOMER).
3) MAKE A LIST OF CATEGORIES AND NUMBER OF BOOKS IN EACH CATEGORY, SORT BY CATEGORY NAME.
4) FIND OUT HOW MANY BOOKS ARE IN EACH ORDER, SORT ORDERS BY ORDER#. – TWO QUERIES A) AND B)
-A) ONE QUERY SHOWS HOW MANY DIFFERENT ISBN NUMBERS IN EACH ORDER (DIFFERENT BOOKS)
-B) ANOTHER QUERY SHOWS HOW MANY PHYSICAL COPIES OF THE BOOKS COMBINED, THAT IS PRESENTED BY “QUANTITY” FOR A SPECIFIC ISBN IN ONE OF YOUR TABLES.
YOU WOULD NEED TO FIND THE SUM OF THESE QUANTITIES FOR AN ORDER

book Oracle 12c SQL by Joan Casteel (2).pdf

Choose the data file that sute the question from the attached list

DATA FILES FOR ORACLE 11G BOOK, CAT9 LOG-IN BELOW

finally I have a test similar to this question after two days so it will be great if you will be available for another task

there is 4 more JLDB files will attach later