Using SQL Developer to execute the following queries. (Chp. 9: Joining Data From Multiple Tables) *Oracle 12c SQL* Table Names: ACCTBONUS, ACCTMANAGER, ACCTMANAGER2, AUTHORBOOK, AUTHORBOOKS, CUSTOMERS, EMPLOYEES, ORDERITEMS, ORDERS, PROMOTION, PUBLISHER, PUBLISHER2, PUBLISHER3, TESTING, WAREHOUSES. Schema of tables not required.
1. Write a query to display the title and publisher, as well as the publisher contact for each book using the JOIN...USING clause.
2. Write a query to show the first and last names of customers who have ordered cooking books. Use the WHERE clause to join the tables.
3. Write a query to show the title, cost, and ISBN of each book in the books table. If the book has been ordered, show the order number and order date. Use the OUTER JOIN keywords to join the tables. Sort the titles in alphabetical order.
4. Write a query to show the gift a customer will receive if he or she orders Database Implementation. Use either the WHERE clause or a JOIN keyword to join the tables.
5. Write a query to show the profit of each book sold to Leila Smith. Calculate the profit by subtracting the cost from the paid each column in the orderitems table. Use the WHERE clause to join the tables.