Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started