Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

Based on the relational schema below, write SQL commands for the following problem. Note that "*" at the end of attribute name indicates that the...

Based on the relational schema below, write SQL commands for the following problem. Note that "*" at the end of attribute name indicates that the attribute is a FK. PRODUCT.PRICE is a selling price; SUPPLY.S_PRICE is a supplying price.

(Show SQL statements only; no need to show output).

PRODUCT (P#, P_NAME, PRICE, QTY)

SUPPLY(S#*, P#*, S_PRICE)

SUPPLIER(S#, Sname, City).

a.) Find all supplier names and cities who supply expensive chairs, where expensive chairs are those whose selling price is greater than $300.

b.) Find all the product numbers whose selling price is greater than that of DRESSER ?

c.) Find minimum, maximum, and average selling price of products from each supplier.  Show also Supplier number and supplier name.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question