Use SQL Developer to execute each of the queries below. This needs to be done in SQL. Please post the code for each question number. (I have also provided the tables below).

1. Write a query to show the title 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.
2. 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.

Tables v Relational Tables V ACCTBONUS AMID AMSAL REGION > Constraints > Indexes V ACCTMANAGER AMID AMFIRST AMLAST AMEDATE AMSAL AMCOMM REGION > Constraints > Indexes V ACCTMANAGER2 AMID AMFIRST AMLAST AMEDATE REGION > Constraints > Indexes AUTHOR AUTHORID LNAME FNAME > Constraints > Indexes v BOOKAUTHOR ISBN AUTHORID > Constraints > Indexes V BOOKS ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY Constraints > Indexes V CUSTOMERS CUSTOMER# LASTNAME FIRSTNAME ADDRESS CITY STATE ZIP REFERRED REGION EMAIL > Constraints > Indexes v ORDERITEMS ORDER# ITEM# ISBN QUANTITY PAIDEACH > Constraints > Indexes ORDERS ORDER# CUSTOMER# ORDERDATE SHIPDATE SHIPSTREET SHIPCITY SHIPSTATE SHIPZIP SHIPCOST > Constraints > Indexes PROMOTION GIFT MINRETAIL MAXRETAIL > Constraints > Indexes V PUBLISHER PUBID NAME CONTACT PHONE > Constraints > Indexes TESTING ID TVALUE DESCRIP > Constraints > Indexes