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 that shows the titles, wholesale prices, retail prices, and categories of books that sell for more than $35 but less than $60. Order the results by title.
2. Write a query that shows the title and ISBN of books that are in the computer category.
3. Write a query that lists the last name, first name, address, city, state, and zip for customers whose last names start with L.
4. Write a query that displays the titles of books in the family life and fitness categories using the IN operator.
5. Write a query that lists the order number and order date of each order that has shipped. Order the results by order date.

V Tables Relational Tables V ACCTMANAGER AMID AMFIRST AMLAST AMEDATE AMSAL AMCOMM REGION > Constraints > Indexes V ACCTMANAGER2 AMID AMFIRST AMLAST AMEDATE REGION Constraints > Indexes V AUTHOR AUTHORID LNAME ENAME > Constraints > Indexes BOOKAUTHOR ISBN AUTHORID > Constraints > Indexes 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