Question: Use SQL Developer to execute each of the queries below. This needs to be done in SQL . Please post the code for each question

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 lists the last name, first name, address, city, state, and zip for customers whose last names start with L.
  2. Write a query that displays the titles of books in the family life and fitness categories using the IN operator.
  3. Write a query that lists the order number and order date of each order that has shipped. Order the results by order date.

Use SQL Developer to execute each of the queries below. This needsto be done in SQL. Please post the code for each questionnumber. (I have also provided the tables below). Write a query thatlists the last name, first name, address, city, state, and zip for

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!