Use the relational schema of Pine Valley Furniture (PVF) database system to crea

ID: 3698094 • Letter: U

Question

Use the relational schema of Pine Valley Furniture (PVF) database system to create and execute SQL queries. Here is the relational schema:

pvf_cust (cid, name, address, city, state, zipcode)

pvf_order (oid, orderdate, cid)

cid is a foreign key references customer(cid)

pvf_product (pid, prod_desc, prod_finish, price, prod_line_id)

pvf_order_item (oid, pid, quantity)

oid is a foreign key references pvf_order(oid)

pid is a foreign key references pvf_prod(pid)

1. Retrieve information of the most expensive product. Display its product description, finish, and price.

I have provided thecreate statements in previous solutions.

The required query will be :

select prod_desc, prod_finish, price

from pvf_product

where price = (select max(price) from pvf_product ) ;

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.