Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
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.