I actually need someone who is experienced in Oracle SQL/iSQL so I can get some help with some homework problems. I want an expert's answers to all my questions so I can match them to mine. Here are the questions and I will attach the SQL file to this project so you can execute it.
1. What books did the author who sold the most books write?
2. What were the names of people who got a book cover with their orders?
3. List all the customer names and the names of people who referred them, if they were referred. Put in “not referred” if the customer was not referred.
4. What were the names of the books that were sent to the state that received the most books?
5. What author made the most profit?
6. What was the profit made on each of the books that the author in #5 sold?
7. What are the names of the books and author's names of the books with multiple authors?
8. Which customer (name, please) placed the most orders, and what did he order?
9. Did any customers ship the books to an address that they don't live at?
10. Which customer made the most profit for the company?
Contact me on PMB for questions.