Question
Use the relational schema of the Pine Valley Furniture (PVF) database to create and execute SQL queries. Here is the relational schema: pvf_cust ( cid
Use the relational schema of the Pine Valley Furniture (PVF) database 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 cust(cid)
puf_product (pid, prod_desc, prod_finish, price, prod_line_ id)
puf_order_item (oid, pid, quantity)
oid is a foreign key references pvf order(oid)
pid is a foreign key references pf _prod(pid)
For each order that contains product 2 (pid-2), display the oid, orderdate, pid, and quantity. Sort the results by order date in descending order.
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