I am trying to figure out how to do some sql queries and I cant figure these out:

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 Holy Grail of Oracle. Use either the WHERE clause or a JOIN keyword to join the tables.
3. Write a query to show the profit of each book sold to Jake Lucas. Calculate the profit by subtracting the cost from the paideach column in the orderitems table. Use one of the JOIN clauses to the join the tables.

ORDERS CUSTOMERS Order Customer# Orderdate snipdate Shipstreet Shipcity Shipstate Shipzip Shipcost Customer# Lastname | Firstname Email Address Ci Sta Zip Referred Region BOOKAUTHOR AUTHOR BOOKS ISBN Title Pubdate PubID Cost ISBN AuthorlD AuthornD Lname Fname ORDERITE Order I tem# ISBN QuantityRetal Discount Category Paideach PUBLISHER PublD Name PROMOTION Contadt Phone Gft Minretail Maxretail