Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

List the unique product IDs, product descriptions, and prices, of all products that were ordered in quantities of less than five. Sort the list by

image text in transcribed

List the unique product IDs, product descriptions, and prices, of all products that were ordered in quantities of less than five. Sort the list by price in descending order.

For each product of the Modern or Classical product lines, list the product description and ID along with the total quantity ordered of that product. Sort by product description

CHIRYAN PAYMENT T PAYMENTD ORDERIC PAYMENTTYPEID VARCHAR2 (50 BYTE) PAYMENTDATE PAYMENTAMOUNT NUMBER (6,2) PAYMENTCOMMENT VARCHAR2 (255 BYTE) NUMBER (5) NUMBER (5) DATE PAYMENT-PK/PAYMEN TIO) PAYMENT-PK (PAYMENT!D) CHORYAN ORDERT PORDERID NUMBER (5) NUMBER (4) DATE CUSTOMERID ORDERDATE FULFILLMENIDATE DATE SALESPERSONID NUMBER 4) SHIPADRSID C##RYAN.SALESPERSON T SALESPERSONID SALESPERSONNAME SALESPERSONTELEPHONE VARCHARZ (50 BYTE) SALESPERSONFAX SALESPERSONADDRESS VARCHAR2 (30 BYTE SALESPERSONCITY SALESPERSONSTATE SALESPERSONZIP SALESTERRITORYID NUMBER() ARCHAR2 (25 BYTE) NUMBER 4) ORDER PK {ORDERID) C##RYAN.ORDERLINE T VARCHAR2 150 BYTE ORDER PK (ORDERID ORDERLINEID ORDERID NUMBER (4) NUMBER (5) NUMBER (4) ORDEREDQUANTITY NUMBER (10) ARCHAR2 (20 BYTE) CHAR 12 BYTE VARCHAR2 (20 BYTE) NUMBER (4) FPRODUCTIO ORDERLINE_PK (ORDERLINEID) ORDERLINE-PK(ORDERLINEID) SALESPERSONPK(SALESPERSONID) SALESPERSON PKSALESPERSONID - CK#AYAN.PRODUCT T PRODUCTID PRODUCTLINEID PRODUCTDESCRIPTION PRODUCTFINISH PRODUCTSTANDARDPRICE NUMBER (6,2) PRODUCTONHAND NUMBER (4) NUMBER (4) VARCHAR2 (50 BYTE VARCHAR2 (20 BYTE) C##RYAN.PRODUCTLINE PRODUCTLINEID NUMBER (4 PRODUCTLINENAME VARCHAR2 (50 BYTE) PRODUCTLINE_PK (PRODUCTLINEID PRODUCTLINE PK (PRODUCTLINEID) NUMBER (6) PRODUCT PK (PRODUCTID) PRODUCT-PK(PRODUCT!D) CHORYAN PRODUCEDIN PF PRODUCTID PF* WORKCENTERID NUMBER (4) VARCHAR2 (12 BYTE) PRODUCEDINPK (PRODUCTID, WORKCENTERID PRODUCED!NPK(PRODUCTID WORKCENTERID)

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

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions

Question

2. Why has the conflict escalated?

Answered: 1 week ago