For EACH of the questions create TWO scripts, one using: a) traditional join with the WHERE clause AND another one using: b) ANSI join with the JOIN keyword Q1 List the book title, publisher name, contact, and contact phone number for all computer books with a retail price under $100. Q2 List all book titles and the first and last names of the customer(s) who ordered each title. Be sure to show the titles of the books that were not ordered. Q3 Use the MINUS operator to list the publishers who have not published any cooking books. The MINUS operator will make this much easier. Q4 List the ISBN, title, author last name(s), retail price, and the promotional gift for all books. For books with multiple authors list both author's names but it is also OK if only one was provided.

CUSTOMERS Customer Lastname Firstname Email Address City State Zip Referred Region ORDERS Order# Customer Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order# Item# ISBN Quantity Paideach BOOKAUTHOR AUTHOR BOOKS ISBN Authord ISBN AuthorID Lname Title Fname Pubdate PubID Cost Retail Discount PUBLISHER Category PublD Name PROMOTION Contact Phone Gift Minretall Maxretail FIGURE 1-5 JustLee Books's table structures after normalization