Question: Answer in sql please. ORDERS CUSTOMERS Order Orderdate stname Shipdate FirstnameShipstreet Shipzip Zip Referred Region 800 ODKAUTHOR AUTHORS AuthoriD ORDERITEMS Pubdate PubID Cost Retal Discount

Answer in sql please. Answer in sql please. ORDERS CUSTOMERS Order Orderdate stname Shipdate FirstnameShipstreet

Shipzip Zip Referred Region 800 ODKAUTHOR AUTHORS AuthoriD ORDERITEMS Pubdate PubID Cost

ORDERS CUSTOMERS Order Orderdate stname Shipdate FirstnameShipstreet Shipzip Zip Referred Region 800 ODKAUTHOR AUTHORS AuthoriD ORDERITEMS Pubdate PubID Cost Retal Discount Order ISBN Quandty DetountPUBUSHERS Paideach Name PROMOTION Contact Phone Gift Minretall Maxretal Problem: Produce a list of all customers who live in the state of Florida or Texas and have ordered computer books that has an ISBN starting with '83'. Display only those orders that have been shipped. Sort the results in descending order of custome r# LASTNAME ST ORDERD SHIPDATE ISBN CATEGORY 1007 GIANA TX 1001 MORALES FL 1007 84-APR-15 8843172113 COMPUTER 1003 88-MAR-15 8843172113 COMPUTER FOUR SQL STATEMENTS ARE REQUIRED by using the (1) implicit join. 12) explicit

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!

Unit 6 Lab - SQL statements - Need help on these CIS 338: SQL/Oracle Learning Unit 6: Lab Activity Lab Activity Complete the following SQL exercises using the JustLee Books database. Launch Oracle...

Show the total number of customers who have placed an order for books Sam Smith has written. this is for SQL oracle 12c book (Database) ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity...

How would you determine which orders have not yet been shipped to the customer? Figure 1-5: ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost CUSTOMERS...

Which tables and fields would you access to determine which book titles have been purchased by a customer and when the order shipped? Figure 1-5: ORDERS Order# Customer# Orderdate Shipdate Shipstreet...

Explain how you would determine how much profit was generated from orders placed in April 2009. Figure 1-5: ORDERS Order# Customer# Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost...

Create reports containing the following details from the database: Q1 List all order numbers and their ship dates for orders shipped after March 15, 2018. Q2 List all customers that live in...

The normalization process was shown for just the BOOKS table. The other tables in the Just Lee Books database are shown after normalization. Because the database needs to contain data for each...

If a customer inquired about a book written in 2003 by an author named Thompson, which access path (tables and fields) would you need to follow to find the list of books meeting the customers...

If management needed to determine which book category generated the most sales in April 2009, which tables and fields would they consult to derive this information? Figure 1-5: ORDERS Order#...

SQL QUESTIONS: 1. 2. 3. 4. 5. CREATE TABLE Customers (Customer# NUMBER(4), LastName VARCHAR2(10) NOT NULL, FirstName VARCHAR2(10) NOT NULL, Address VARCHAR2(20), City VARCHAR2(12), State VARCHAR2(2),...

Determine the present value of the following single amounts (EV.of $1. PV of $1. EVA of $1. PVA.of $1 EVAD ofS1 and EVAD of S) (Use oppropriate factor(s) from the tables provided. Round your finel...

Describe, qualitatively, what happens in a distillation column during cold startup (operating under total reflux). Assume that, during start-up, the column is operated with no distillate draw, and...

Based on the capital asset pricing model, investors are compensated based on which of the following? L . market risk premium II . portfolio standard deviation III. portfollo beta IV . risk - free...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

The Reconstruction and Development Programme (RDP) in part tries to meet this need and has a large commitment to educational provision and people development.

Trade unions and employer associations. These act as pressure groups and can influence employment relations depending on their relative strengths.

Approximately 11,300 affirmative action posts have been allocated in the public sector since April 1994 (Horwitz et al., 1996).