Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

4th Edition

ISBN: 0805360476, 978-0805360479

More Books

Students also viewed these Databases questions